By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,806 Members | 1,490 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,806 IT Pros & Developers. It's quick & easy.

Using multiple tables in one form.

P: 4
Hi Ö

Iím very new to using MS-Access and I need some help.

I work for a medical device company and prior to me coming on board they tracked ECO (Engineering Change Order) Numbers using pen & paper. Iíve created a Table (Table-A) to automatically assign an ECO number, track who the originator is, the product line being affected, and status of the ECO.

Iíve set this up so that Table-A stores information for the Originator (Table-B), Product Line (Table-C), and Status (Table-D) from separate Tables. Iíve also created a database interface page to input the required information into Table-A.

My question is Ö How can I get my (interface) Page to read directly from Tableís B, C, and D that will then store this information into Table-A ?

Any assistance will be greatly appreciated.


Jul 24 '07 #1
Share this Question
Share on Google+
1 Reply

P: 39
if table a has all of the same feilds why not store it all in table a.

it sounds like you dont need the other tables

Jul 25 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.