I still can't figure out the problem. And MS tech support doesn't seem to have the answer either. Anyway, I modified my table to make it completely flat, so no other tables are involved. So, now I have the following table:
ID-------Value------UniqueVal-----Cost--Quantity--MarketVal...
I have a single table with over thirty columns of numeric data. The first column is a text description of the field I want to lookup. So as an example, I have:
ID Lookup_Value Return Value Quantity Cost
1 Quantity 100 100 80
1 Cost 80 100 80
2...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.