Someone Please Help!!!!
Im not the greatest on access but have to cover it for my NVQ. i have to produce a multiple table database which i think i have done quite successfully.

The database i currently used had one table which contains approx 50 fields. i have since split this table into 5 tables including the original. all 5 tables are set up and everything. i have a manual table which was the original 50 field table but narrowed down now. i have a additional info table, location table, model table and finally an account table. each of these tables have around 4 fields in each which were taking from the manual table. i also have a query that brings all 5 tables together so it looks how the manual table did before i split it.

the problem i am having is with a data entry form. the original form was used so data could be added to the manual table. now i need to alter this so if a new location is to be added it will be added to the location table, if a new account is to be added it is added to the account table and so on. i would also like it to show details on tables. so when i split it on the location table u have the + button and when it is clicked shows all the records under that location.



is there a way i can do this where the query i have created will automatically update if any new records are created aswell?

i have spent a long time trying to sort this out, playing around with the control source, the relationships etc but it has defeaated me!!