Hello,
I am trying to create a database that is used to describe the equipment and piping (and their links) around a chemical plant.
The desired output is a report table that contains the following data:
Size Code Seq Spec From To 100 PG 001 A1 Inlet 1 150-PG-002-A1 150 PG 002 A1 Inlet 2 V-001 Separator 150 PG 003 A1 V-001 Seperator Outlet 1 50 PG 004 A1 150-PG-003-A1 Outlet 2 50 PL 005 A1 V-001 Separator P-001 Pump 50 PL 006 A1 P-001 Pump Outlet 3
I have created two tables with the following data (to allow for other queries and sorting)
Size Code Seq Spec 100 PG 001 A1 150 PG 002 A1 150 PG 003 A1 50 PG 004 A1 50 PL 005 A1 50 PL 006 A1
Tag Seq Description V 001 Separator P 001 Pump
What I would like to do is being able to populate the "from" and "to" fields using a combobox referencing either the lines or equipment tables or alternately entering in a value manually such as the "inlet" or "outlet" entries above. I have also attached a picture to illustrate the arrangement I wish to describe. Of course any changes made in the line or equipment tables should automatically be reflected in the "from" and "to" fields.
I am new to MS Access and databases in general so hopefully I have explained my problem properly. Any help would be greatly appreciated.