If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Validation Listing
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.... |
#2
|
|||
|
|||
Validation Listing
"Marv" wrote in
: 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 |
#3
|
|||
|
|||
Validation Listing
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 -----Original Message----- "Marv" wrote in : 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 . |
Thread Tools | |
Display Modes | |
|
|