I am working on a rental store database. I have MANAGE table like the following:
ItemNo Direction ClientName DateOfProcess
45------ OUT----John-------- 27/12/2010
34 ------IN------Green------- 5/1/2011
9...
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...