relationships in Forms

[JonatABS]

Why when I try ot create relationships I only see one table in the relationship dropdown. I have 6 tables, they should all appear in that drop down should they not?

 

[Robert Dunstan]

Hi there,

I'm afraid your post is a little vague so I'll try to help as best I can.

Firstly you say that you are trying to create relationships. You have to create relationships between your tables in the 'Relationships' window. All the tables you have created should show.

Secondly if you are creating a form that is to be used to display/enter data into 2 or more tables then first create a query based on the tables that you want the set this query as your form's record source.

HTH
Rob