Hello,
I have divided a very large table by sectioning off 4 smaller tables; they each have fields relating to a common topic AND the primary key of #1, which is an automatic-numbering type. I kept the pared down #1 with the basic information; it will be used in almost every query.
At the moment, each of the 4 new tables has their own (auto-numbered) primary key and, as a secondary key, #1's primary key (CoreID). (I copied the original table 4 times and deleted the unwanted fields, so #1s primary key is correct when the tables are matched.)
These would all be in a one-to-one relationship with each other.
But, now, I have a couple of questions:
- I now see that I don't have the secondary keys set up in a way that will allow me to add/delete records and have the rows adjust in the other tables. Can you tell me how I should back up and handle this? Is this a referential integrity issue, or a structural problem?
- Should every table relate to every other table? or all only to #1?
Thanks for help and suggestions!