Hello,
I created following tables:[tblSizes] & [tblItems]
[tblSizes]
SizeID (number)--KeyField
WeightFm (number)
WeightTo (number)
Sample data =
Record1: 1.00 (=SizeID) 1.00( = WeightFm) 1.49( = WeightTo)
Record2: 1.50 (=SizeID) 1.50( = WeightFm) 1.99( = WeightTo)
Record3: 2.00 (=SizeID) 2.00( = WeightFm) 2.99( = WeightTo)
[tblItems]
ItemID (number)--KeyField
....
ItemWeight (number)
SizeID
....
Now, everytime I add a new record in tblItems, I will enter the ItemWeight.
The SizeID, however should automatically be retrieved (according to the
ItemWeight) from the table tblSizes.
e.g. ItemWeight = 1.39 ---> SizeID = 1.00
e.g. ItemWeight = 2.19 ---> SizeID = 2.00
How do I accomplish this?
Thanks for any help!
--
Reginald Bal