unable to enter data into a form

[database user]

Hi,

I'm working with Access 2003. I have 3 tables in my relational database. I
am trying to create a form using fields from all 3 tables. I can not enter
data into the fields for one of my tables. I believe the relationships are
correct. No error messages occur. Can someone help?

 

[RBear3]

What kind of relationships are they? If you are trying to enter data on one
form for three tables, they would probably need to be one-to-one
relationships. Is that correct?

Typically, one table would be updated from the form, and related tables
would be updated using subforms, or functions to pop up other forms.

 

[database user]

Thanks RBear3. The relationships were both one to many. Are you saying
because they are not one to one I need to create subforms?

 

[RBear3]

Well, if you have one customer and he has five employees, you have another
customer with 8 employees, and another with 50 employees, how can you do
that on one form? You will have one record in your "customer" table and
many records in the "employee" table. You can't get that in one form.
Instead, you'd have your customer data on the form, then a subform with one
or more (or none) employees.

For another example, you might have a "person" in your main form/table and
their children in a related table. Again, in a one to many relationship,
you would have one child for some people, two children for others, and ten
kids for others. There is no way to do that on one form.

 

[scubadiver]

Here endeth the first lesson!

Set your forms up using the wizard. Select the fields from the appropriate
tables and the wizard can give you options on how you want your forms to look.