updating a mastertable from two tables?

[Brook]

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
..

 

[Eric Butts [MSFT]]

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
(e-mail address removed)
"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" <[email protected]>
| Sender: "Brook" <[email protected]>
| Subject: updating a mastertable from two tables?
| Date: Thu, 29 Jul 2004 12:37:11 -0700
| Lines: 20
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Thread-Index: AcR1o3FmuT0Wo+jdSHiqMkpXxR1ySQ==
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Newsgroups: microsoft.public.access.tablesdbdesign
| Path: cpmsftngxa10.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.access.tablesdbdesign:82157
| NNTP-Posting-Host: tk2msftngxa12.phx.gbl 10.40.1.164
| X-Tomcat-NG: microsoft.public.access.tablesdbdesign
|
| 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
| .
|
|
|