I need to lookup from my form the bank being used starting balance. The form has the bank and bankid on it.
table where data is stored is TBanks field to lookup is startingbalance
I need it to show the matching bank & id on the form:
Example; Bank name is Bank of America with a bankid of 14 which is it's primary key.
Form is named FReg and has the bank and bankid on it.