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