snoopy92211
Technical User
Ok. This is driving me insane! I have a table, BankData, that lists bank information. It's a pretty simple table, just a primary key, and a bank name.
I have several tables that use this bank name as a field.
For example, I have an Investments table that uses a bank name field(field name is Borrower). For this field, the lookup is:
Data Type: text
row soure type: table/query
Row source query: bankdata
Bound Column: 1
Column Count: 2
Column Width 0";1"
This works fine! however, when I'm creating a Form based on the investments table, and i use the 'Borrower' field, I only see the corresponding Id Number, when I really want to see the bank name.
Now, I realize that I can just make the row source for this form field bankdata, but...when I select a bankname that isn't in the investments table (Borrower field), the form is empty.
Hope this isn't convoluted.
I just want to be able to see the name of the borrower on the field and filter from there, instead of the corresponding ID number.
HELP!!
Thank You
I have several tables that use this bank name as a field.
For example, I have an Investments table that uses a bank name field(field name is Borrower). For this field, the lookup is:
Data Type: text
row soure type: table/query
Row source query: bankdata
Bound Column: 1
Column Count: 2
Column Width 0";1"
This works fine! however, when I'm creating a Form based on the investments table, and i use the 'Borrower' field, I only see the corresponding Id Number, when I really want to see the bank name.
Now, I realize that I can just make the row source for this form field bankdata, but...when I select a bankname that isn't in the investments table (Borrower field), the form is empty.
Hope this isn't convoluted.
I just want to be able to see the name of the borrower on the field and filter from there, instead of the corresponding ID number.
HELP!!
Thank You