Tying tables to forms

[Guest]

I have four connected tables that work well as table input but when I put
them in a form some of the fields will not let me make entries. Does this
happen because I am using the Id fields and subsequent data from the wrong
tables?

 

[Guest]

It sounds like you have created a non-updatable form.

One cautionary note first:
Don't tie your forms directly to the tables. Use queries instead. The
queries will act as a stop light for which data is written and when. If more
than one person tries to make a change to the same record at the same time,
you will run into problems.

From what you have written, you are linking several tables to one form. If
the relationships between these tables is not set correctly, Access will not
know how to relate the information being entered. That is probably what is
happening.

Create a select query that contains the tables with the relationships as you
think they should be. Execute that query and look in the lower left hand
corner. You may see a note saying that this query is not updatable. If that
is case then your relationships are ambiguous.

PJ

 

[John W. Vinson]

I have four connected tables that work well as table input but when I put
them in a form some of the fields will not let me make entries. Does this
happen because I am using the Id fields and subsequent data from the wrong
tables?

Probably, but you don't say how you've done it.

If you're basing the Form on a massive query combining four tables... you're
on the wrong track. It's much better to have a Form (for the "one" side table
in a one to many relationship) and one or more Subforms (for the related
"child" tables).

John W. Vinson [MVP]

 

[Guest]

My tables are: Organization - Subspecialty - Subspecialty Details (info
changes yearly) - Customers - Orders - Orders Details. How would you suggest
combining tables for queries?

 

[John W. Vinson]

My tables are: Organization - Subspecialty - Subspecialty Details (info
changes yearly) - Customers - Orders - Orders Details. How would you suggest
combining tables for queries?

I have no way to know, because I don't know the structure of your tables, how
they are related, what real life entities they represent, or how they are
related.

And I did not suggest combining tables for queries. Instead, I suggested using
Forms and Subforms. For example, you could have a form based on Orders with a
subform based on Orders Details. I don't know enough (any!) about your
business to be much more specific though!

John W. Vinson [MVP]