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