Forms and relations

[Andren]

I have a silly question.
(Silly - because I should by now know...)

Anyway.

I have had problems with forms built upon a query consisting of several tables. One of these (the Master) have a one to many relationship with other tables.

If I on the form (built from the query) start to put in data in fields related to the "Master-table" I get an error saying "key not in the recordset". But that is not true. The key is there.

Now - is it so, that you FIRST have to enter information on a form in fields related to the tables having a "many-relationship" to the Main table ?

In other words - is relations among tables important for what fields you start with, on a form - even if the form is built upon a query?

I hope I make myself clear on this matter.

/ Anders

Or are you free to put in

 

[Pat Hartman]

When you have a 1-to-many relationship, it is best to build a form (for the 1 side) with a subform (for the many-side). I never do it any other way.

If you insist on using a single form, then the fields of the 1-side table need to be filled in first.

 

[Andren]

Thanks!

Thanks!
Deep inside me (very very deep) I knew this, but I was unsure.
You relieved my tension about this matter.
Thanks again.

/ Anders