i need to link machines

[Chimp8471]

i have a number of filling lines in the company where i work, layout a little similar to the layout below.

what i need to do is to link the lines with the machinery attached to it.

as you can see each line may be different, but there are also a number of lines that have the same layouts.

any tips on the best way to go about this please.

i have attached a couple of tables on the DB below

Cheers

Andy

 

[Len Boorman]

Think you need to uniquely identify the lines.

Have a table of Uniquely identified items.

Printer 1
Printer 2
Printer 3

Etc

The a Line/Equipment Table

Line 1 Printer 1
Line 1 Machine 2
Line 1 Machine 3
Line 2 Printer 2
Line 2 Machine 4

Need to be careful with the links. Suggest there are 1:1 links since a particular machine can only be on 1 line at any time.

HTH

Len B