G
Guest
Hello - I will try to make this complicated problem sound as simple as I can...I have a database that has so much information about the same objects that all of the fields would not fit on one table. So, there are four tables, each linked by the Primary Key number , describing the same object (in this case, the objects are hot springs, and the tables are Isotopes, Trace Elements, Gas, etc.).
It was easy enough to get all of the data that already exists into the table and make sure the appropriate Primary Key number went to the correct hot spring for each table. The problem now is that more data entry is needed, and I cannot be sure that the new number to be entered as the Primary Key for one table will be for the same spring on another table. I need some way to link all four tables on a form that, as a number is entered in one form, the remaining tables are updated so that the same number cannot be used for two or three different springs. I have absolutely no idea how to do this. Does anyone have suggestions? Many thanks in advance!
It was easy enough to get all of the data that already exists into the table and make sure the appropriate Primary Key number went to the correct hot spring for each table. The problem now is that more data entry is needed, and I cannot be sure that the new number to be entered as the Primary Key for one table will be for the same spring on another table. I need some way to link all four tables on a form that, as a number is entered in one form, the remaining tables are updated so that the same number cannot be used for two or three different springs. I have absolutely no idea how to do this. Does anyone have suggestions? Many thanks in advance!