I have one table that contains certificate numbers and then I have another table that has customers. When adding or editing a customer, you can use the record picker to select the certificate that the customer is calling in about. How can I then lock that certificate so that it cannot be selected again by another customer? What I am running into, is more than one customer has the same certificate chosen, which cannot be possible.
Thank you!!!!
------------------------------
Kim Cameron
Admin/Sales
Vacation Tour & Travel
Conway AR
15013295434
------------------------------
Question
Record Picker
+5This topic has been closed for replies.
+24np,
you have the Relationship.
One Certificate has Many Customers.
Make a summary to count customers.
Make a report called Available certificates filtered where [# customers] =0
set the form to use that report for the drop down field on the form.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.