Data Entry Form

[Stan Denman]

I am fairly new to access. I need to create some data entry forms. I have a contact table that relates to an address table on a many to one. (one address per client, but an address could house more than one client). My problem is that I have lots of clients for who I do not have an address, because of the hassle of entering the addresses. When I create a query with tblcontacts and tbladdresses of course I only get records for which a given client has an address in the tbladdresses. When I relate such that a record show for the Address table for each contact (blank records in the address table) I am unable to enter address data. Any help would be most appreciated.

[rzw0wr]

Sounds like a little table work will solve your problem.

Google normalize tables and take a look again at your table structure.

Believe me a little work now will save you tons later.

Either upload you database or give us a picture of your stable relationships.


Dale