I have had great success building join table records and scripting connections between all of the tables. Until now....I am now building the "Marketing" table, which will contain a LOT of information. for example, as part of Marketing, we want to log our Catalog Distribution. We will have fields such as "Ship Date", "# of Catalogs", etc. Each contact or each organization and event can have multiple Catalog Shipment records related to them with different dates and numbers for each shipment. Do I need to make a new base table for that and build it the same way I did all the other ones? Or do I attach that somehow to the right of the "Marketing" base table and attach it to each of the occurrences of the other tables? And if I do that, how would I work the pk and fk fields?
I'm a bit unsure of how to proceed at the moment. I will have three of these sort of "subgroups" keeping track of detailed correspondence such as advertising and communication with the other base table groups.
Thanks for any advice!