changing data

[JEPE]

Hi,
I have a continuous form based upon a query.
This query links 2 tables
I notice I can not change the values in the continuous form because (I
think) it is based upon this linked query..
Am I wrong and is there a way to solve this?
Thanks
JP

 

[Tieske]

my guess would be you have joined the tables on a "one-to-many" relationship.
In these cases you can only update the fields on the "one" side, unless you
select "cascade updates" for the relationship, but be sure you want to do
this before you enable it.

for example you have 1 article, but it is linked to many orders on which
that article was ordered. If you now have a query showing all articles for a
specific order, and you would update the description of that article, you
would implicitly update the description on ALL orders that list this article,
not just the one you are editing.

hope this helps.

 

[JEPE]

thanks for your kind help...

Where to change the relationship to this "cascade updates"?
Thanks

 

[Tieske]

access 2008; ribbon "Database Tools", click "relationships"

Here add the tables and create the relationships by dragging the linked
field from one table to the other. Then you get the options to do this.
If you already created the relationship, doubleclick it.

other Access versions: check help on "relationships" or "enforcing
referential integrity"