Record Picker
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 th...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendnp,
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
------------------------------