Relationship Desing

[aponne1]

Hi, I have 3 tables: Address, User, & Payment. The relationships are set so
the User table has an addressID which is linked to the Address' table ID
field and the Payment table has a userID which is linked to the User's table
ID field. I want to build 3 forms, one that will display information from
all three tables for a given address, another that will let me add new
records to the User table that lets me choose an address to link it to, and
third a form that let's me add records to the Payments table by selecting an
address and linking the UserID to the record.
I'm stuck on building a form that pulls an addressID from the Address table
and entering in a new User name in the User table. I'm using a combobox for
the Address whose control source is the addressId of the Address table and a
textbox for the User whose control source is the User field in the User table
and I get a "#Name?" error for the textbox, and in the combobox I get the
list of addresses but I can't select any of them. Any ideas on whats wrong
with this form or how to go about desinging the others? Thanks!

 

[Roger Carlson]

Before going any further, I'd like to make sure you've got your
relationships right.

By your description, each Address can have multiple associated Users, but
each User can have one and only one Address. Is this correct? If not,
that's the basis of your problem.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[aponne1]

That's correct, each Address may have multiple Users, and each User can have
only one Address.