See attached 2 tables as example. I want to connect on VolumeCategory. So: an ID with a certain VolumeCategory needs to get the connecting tariff (talbe 2 = tariff table). In Excel I would use hlookup. In access so far I have manually changed table no 2 to something like table no 3 and then connected it on VolumeCategory. But there must be a smarter way to directly query table 1 with table 2. My "tariff table (table no2) has grown now to 52 categories and each time manually "rewriting" is getting me somewhat feeling stupid.
Can someone tell me what the solution is?
Thx for all the help!
Lobhaan
Can someone tell me what the solution is?
Thx for all the help!
Lobhaan