In my database 2 table:
Table "Cylinders" which contain 2 fields:
- [Cylinder Number] as primary key and on the one side of the relationship- [Cylinder Location] as a lookup field with two values "IN" or "OUT"
Table "Client Deals" which contains 2 fields:
- [Cylinder Number] on the many side...