query update

[DD]

I have a query that is derived from 3 tables with relationships. i want the
user to open a form and be able to change data in that query. i'm assuming
it is not letting me because it is derived from more than one table. is the
only solution to this is to create a table off the query and then base my
form on that table.

wasnt sure if there was a different way around this.

thanks

 

[Rick Brandt]

I have a query that is derived from 3 tables with relationships. i
want the user to open a form and be able to change data in that
query. i'm assuming it is not letting me because it is derived from
more than one table. is the only solution to this is to create a
table off the query and then base my form on that table.

wasnt sure if there was a different way around this.

There are many thing that will render a query as read-only. Having multiple
tables along with the types of joins used and the fields included in the output
is one common reason.

Even when a multi-table query does allow data edits, it is not a great idea as
sometimes the eidts are not applied as you expect.

The best solution is to use a form with subforms. You definitely do NOT want to
make a table from your query.

 

[DD]

how would the form and subform allow this to happen.

thanks

 

[Rick Brandt]

how would the form and subform allow this to happen.

If you have multiple tables in your query that suggests that they have
relationships to each other. In a form with subforms each form is bound to a
single table thus allowing edits and the subforms MasterLink and ChildLink
properties establish the links based on the relationships of the tables.

This causes the subforms to only show the records in their respective table that
are related to the record currently visible in the main form. In addition, any
new records created in the subforms automatically have the related values from
the main form propogated to them.