Hello,
I have created a table base in Access 2010. This consists of a "master" table and ten other "sub" tables linked to this with one to one relationships.
The reason I have set it up like this is because:
- Each Entry contains roughly 200 columns (fields). These fields may change in the future (most likely new ones will need to be added), meaning that to make it easier to update I've separated these into multiple tables.
- IDO NOT have many entries in any of the sub-tables for a single entry in the master table. For every single table there is only one entry each time.
What I want in the end is
- A Navigational User Form that forces the user (the person adding an entry) to navigate through the forms one at a time.
- For the values input by the user to correspond only to a single entry. I.E. I want an interface whereby the user navigates through the forms, going back to make corrections if necessary, then has a button (or similar) that says "add to database" (or whatever), adding all the data in the forms to the tables as a single entry then clearing the forms.
Unfortunately what I currently have is not working like this. The entry numbers are not matched (i.e. I got through the forms and for one table the ID is 2 whereas for another its 3, and sometimes more than one entry has been added).
I'm guessing this has something to do with how I've set up the table relationships. However I don't see how else to do this as I don't want a one-to-many relationship, having only one entry in each sub-table for each entry in the master table.
I've tried to attach my file but it just won't upload. Happy to try and explain if people have questions though.
Does anyone know what I should be doing?
Apologies if the question is unclear, happy to edit it if so.
Many thanks in advance.