Something like Relationship ?!

Discussion created by executor on Oct 13, 2016
Latest reply on Oct 19, 2016 by executor


I have database with several tables. I have table with 1200 seals for water meters. First table is named SEALS have 2 fields – “serial number” and “name”( Нame of an employee of the company. Several different names).

Serial Number     Name

123456                    John

324558                    Kevin

123456                    Ivan

586664                  John

321444                  John


Second Table is named Measurement point and have 2 fields. ID, MP name. Each Measurement point can have 3 seals – Before, After, Door.

At any one time must be able to show list of MP and the seals (serial numbers and name of employee) mounted on this point.

I tried various options, but does not work.