Forms to enter data

[Rabdad Stan E.]

I have a database with three many-to-many relationships. If I could get one
form (based upon a query of course) to work, I could get the other two to
work.
I have a table for individuals (with a few lookup tables attached), a table
for property (with a few lookup tables attached also), and a junction table
between the two tables. This junction table contains some additoinal fields
pertaining to the individual and the property, besides the individual ID
(key) and the property ID (also key).
I have tried to create a form based upon a query that uses fields from all
three tables (individual, property, and junction). but it doesn't let me
enter inofrmation in the form for inclusion in the tables.
Can someone please help me?

 

[bhicks11 via AccessMonster.com]

Try looking at the data in the query before you make the form. Does it show
anything? If not there is something wrong with how you are relating the
tables. If it does, can you change the data at all? If not than you need to
make primary keys in the tables so that the query will be updatable.

Just some initial ideas to look at.

Bonnie

http://www.dataplus-svc.com

 

[Beetle]

A query combining three tables is unlikely to be updateable, and that's not
how it should be done in the first place.

The first thing you need to do is decide how you want to view/enter the data.
In other words, do you want to view each individual in the main form with
all of their related properties in the subform, or the other way around?

For this example, I'll assume the former.

Also, just to clarify, when I say field, I am talking abut a field in a table
or query. When I say control, I am talking about a control (combo box,
text box, etc.) on a form.

The main form would be based on the Individuals table and the subform
would be based on the *junction* table, using IndividualID as the
Master/Child link. In the subform, the IndividualID field would most likely
be hidden (there's really no reason the user's need to see it) and you
would use a combo box control bound to the PropertyID field. The combo
box would *display* the property name (via it's row source) but it would
store the PropertyID (via it's control source). I don't know what other fields
you have in your junction table, so I can't recommend what type of
controls to use for them.