Forum Discussion

KellyBianchi's avatar
KellyBianchi
Qrew Assistant Captain
8 years ago

Can I have a text entry customer-lookup and a related-customer drop-down in the same table regarding the same relationship?

One set of permissions does not allow viewing of all records. So the user must enter an account number to pull of the data. However, Admins are permitted to see all records, and if using a form, I wou...
Ask about Quickbase functionality
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
1. You need to have a traditional drop down relationship.

2. You need to have a field to enter the account number directly.

3. You need to have a relationship where the reference field on the right hand side is a formula field which will calculate to either the [Enter Account#] value or the value from the drop down list.