updating a mastertable from two tables?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brook - 29 Jul 2004 20:37 GMT

I have two tables: tblCustomOrders (uses and autonumber to
create orderID, KI-0000) and tblProgramOrders (uses and
autonumber to create orderID, NW-0000).
The reason for two tables is that custom orders have a
different OrderID than the Program Orders. Both tables
have the same number and type of fields its just the
orderid is different.

I would like to maintain a MasterInventoryTable. Is there
a way that when the data is is create in each of the above
tables, the tblMasterInventory is updated with the record.
And same if the masterinventorytable is edited, the
information be sent to the corresponding table.

Any ideas/suggestions are appreciated.

Brook
.

Reply to this Message

Eric Butts [MSFT] - 02 Aug 2004 00:34 GMT

Hi Brook,

The preferred method would be to use VBA code. If you are NOT into writing
code then you code use Update & Append queries.

Regards,

Eric Butts
Microsoft Access Support
ebutts@online.microsoft.com
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights

--------------------

| Content-Class: urn:content-classes:message
| From: "Brook" <anonymous@discussions.microsoft.com>
[quoted text clipped - 34 lines]
| Brook
| .

Reply to this Message