I created a database with about 8 tables that are related. I created a form to update the information in the tables.
But, the person who entered the data into the database decided it would be easier to enter in separate Excel tables and copy the data into Access.. one table at a time. He was careful to be sure he had the same number of records for each table. But, now I can't get them to relate so I can do any queries or forms on the data. I have a junction table that contains foreign keys for each of the table's primary keys. But, when I look at the junction table, there is no data. Each separate table has data though. Hmmm.. how do I get the relationships to work AFTER data has been entered into the tables separately?
But, the person who entered the data into the database decided it would be easier to enter in separate Excel tables and copy the data into Access.. one table at a time. He was careful to be sure he had the same number of records for each table. But, now I can't get them to relate so I can do any queries or forms on the data. I have a junction table that contains foreign keys for each of the table's primary keys. But, when I look at the junction table, there is no data. Each separate table has data though. Hmmm.. how do I get the relationships to work AFTER data has been entered into the tables separately?
