I need to look up value1 and value 2 from table A, then use value2 to lookup values 3 -6 from table B. LO is not allowing me to use the control name, or the name of the field on the table the form is associated with. Can this be done?
Hello,
This question is hardly different from the last one → Can I return more than 1 value from a table lookup in Base? and the comments there were never responded to. Based upon the information presented you need to write a macro specific to your task. So yes, it can be done, but unless you know how to write LO macros it is very difficult.
Thanks. I’m using Windows 10, LO 6.4, Firebird 3.0. This is for a golf handicap application I am attempting to develop. In this case I was hoping to lookup 2 values (slope and rating) from a table and use them in a calculation with a value entered on a form (score) and create a result (handicap differential). As it turns out, I was able to do this with a query … which brought about my next question.