Action Query

[David Whitaker]

Hi,
Question?
Is there a way to make an action query compare two different fields from two
different tables, then if any changes have occured with specific fields
other than the two mentioned above, change them?
What I am trying to do is to look at a list of vin numbers from a linked
table, then compare the vins with a list of existing vins in the current
dbf, then

1st - if the vin number doesnt exist
add it to the list in the current dbf

2nd - compare other specific fields to see if there data has
changed, then if so
change the fields in the current dbf to match

3rd is a question
if for instance, a vehicle number was changed in the linked dbf, but
the vin number stayed the same, will the records from the current dbf change
through relationships?

I am trying to find a way to keep two diiferent applications current with
each other as to vehicle information, but if any changes are made to the
vehicle as to numbers,plates,etc., (other than vin numbers)change them
accordingl either by adding a new vehicle or changing any/all records to
match.
Sometimes you keep the same vehicle and assign different numbers, but you
want to keep all records associated with the one you just changed.
If with your help if this is realistic, then I can apply whatever to both
application to run this on startup so no user intervention is required.
Thanks for your opinion/help

 

[Guest]

hi,
i don't think you will be able to do this with a action
query. actions querys do something. you need to construct
your code to make decision as to whether to run this
action query or another action query.

changing date in one table does not change data in another
just because they are linked.