ms access - How can I combine two tables and merge fields? -
Sorry this is an incredibly obvious question but I'm new to reaching it and learned it once in the past weeks. Challenging project
Actually I am in the process of preparing a database to track everything to the company: people know this, things happen, meetings happen, etc.
I think I have structured it very well, but what I like is the "activity" table because the activities are diverse, all of which are multiple tables (events, meetings, inquiries, etc.) But all of them have a general description field. Is there a way to create a table or form that will drag it into all the data and keep it like this:
Date-type-details.
The type will come from where it came from, so if the hosting of the meetings was the source of information, then it will be typed as a meeting
I find an easy way to do this It turns out that it is to create an activity table with categories like it seems easy to add to break it, but the number of those areas which would mean that to stay on a table
such a It seems to be simple Education should, but I'm struggling.
Any thoughts? thank you in advanced!