thanks for your kind help...
Where to change the relationship to this "cascade updates"?
Thanks
Tieske wrote:
[Quoted Text] > 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" wrote:
>
>> 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
>>
|