I'm working on a small database for the school I work at to keep student, family and other contacts data.
I've structured my tables so that there is a general (AllHumans) table, and then tables for specific parts of the data (like addresses - which can be shared between many people). In the address table - there is an autonumber field (AddressID) with a corresponding AddressID field in the AllHumans table.
This setup works for existing data (When I imported data, I pre-generated IDs for the field) but when I create a new record - the data is all saved EXCEPT for the AddressID field in the AllHumans table. What do I need to do make sure that the autonumber generated AddressID is also written to the AllHumans table?
Thanks!
Nick