Using multiple tables in one form.

[maze03079]

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.

Thanks,

Brian

[xpun]

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

~john