Validation Listing

[Marv]

I am sorry I caused confusion with not explianing it
fully. First what I have:
Table 1 has a full listing of data. I work off this
listing, so if there is a change in an order I make it on
this sheet.
Table 2 has a full listing of what Headquarters or
corporate sees as my orders, an inventory sheet so to
speak.
I run a comparison query on these two listing to verify
that have all the changes in my orders so the customer
will recieve the order exactly as he needs. Right now
this comparison quirey looks for a difference and brings
up both records so I can visually compare the date (with
any diferences highlighted, so I can easily spot them).
If I find any differences (and unfortuantely there is
usually about 150 differences) - I then have to 1)go back
and resubmit any changes to corperate, using their
inventory roster, or 2) change my worksheet to reflect
the new data.
What I would like to do is to click on the field that
contains the data that I want to change the other
spreadsheet with. Let me re-explain, if the data is
correct (more recent) in the box in the inventory sheet,
I would like to click on that data and have it change the
corresponding field in my work table or if the data is
correct in my work table, I would like to click on that
data and have it change the data in the company inventory
table so I can send it back to them with the correction,
highlighted (the highlighting part I know how to do). In
short I want to automate is the process that is now
making me open the two tables, search for the record, and
then make the change...
Any suggestions?

Marv
PS and sorry again about the confusion before....

 

[Tim Ferguson]

Table 1 has a full listing of data. I work off this
listing, so if there is a change in an order I make it on
this sheet.
Table 2 has a full listing of what Headquarters or
corporate sees as my orders, an inventory sheet so to
speak.

This is not really what you want to be doing with a relational database
design. It sounds as if Table2 is a query or view of the other table: in
which case that is exactly what you should give to Headquarters. Trying to
keep two tables in synch is a dead-end, as you are discovering.

Try modelling your data more on the actual things you are inventorying; and
define the way you want to see it using queries; and organise the way you
want to interact with it using forms; and arrange the way you want to
present it with reports.

Hope that helps


Tim F

 

[Marv]

Thanks Tim... You helped me out ALOT! By challenging me
with the idea that this could not be done... what I did
was update queries, limititng them to just the field that
needed changing... Microsoft has WONDERFUL
capabilities!! Thanks again!

Marv