How can I update multiple tables from value from one table?

[Sukhi]

Hi,
I was trying to figure out a way to get certain records in my
tbl_STOCK_REORDER that have a certain Stock_ID number to update a record in
its main corresponding table. For example a record with ID: SD001 is from
tbl_Stock_Drinks and a record with ID: SC001 is from
tbl_STOCK_CONFECTIONARIES. These records have met criteria and have been put
in tbl_STOCK_REORDER and now i need the right record to go back to the right
table to update the table. (If tht makes sense :S)

 

[Jeff Boyce]

We aren't there. We can't see the table structure you are using. More
specific description may lead to more specific suggestions.

By the way, when you mention "update a record in its main corresponding
table", it isn't clear if you might have a different table for each [Stock].
If so, start looking into "normalization" and "relational" database design.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John W. Vinson]

Hi,
I was trying to figure out a way to get certain records in my
tbl_STOCK_REORDER that have a certain Stock_ID number to update a record in
its main corresponding table. For example a record with ID: SD001 is from
tbl_Stock_Drinks and a record with ID: SC001 is from
tbl_STOCK_CONFECTIONARIES. These records have met criteria and have been put
in tbl_STOCK_REORDER and now i need the right record to go back to the right
table to update the table. (If tht makes sense :S)

If you're trying to store the same information in multiple tables, you are
very much on the wrong track. And if you have data (product categories) stored
in table names and as single letter codes in field values, you're WAY on the
wrong track!

What are your tables? What do they contain?