+5I have a table "Customers" and I have a table "Cruise Certificates". Currently I have a lookup in "Customers" to link the certificate that is issued to the customer. There are times when a customer is issued 2 or maybe 3 certificates. I do not know if I am overthinking it or if I just do not know how, but I need to be able to have 2 or 3 lookups but that will pull different certificates. Is this possible?
+24The right way to do this is to have a Many to Many relationship. This is less scary to set up than it initially sounds.
One Certificate has many Customer Certificates
One Customer has many Customer Certificates.
You just set up that middle (sometimes called "join") table called Customer Certificates and it will actually initially have no fields of its own.
Then you make a those two relationships and you look up down to Customer Certificates the name of the Customer for example and you look up from Certificates the name of the certificate.
Then on the customer record you will have an embedded report of all the Customer Certificates and the set up the embedded report to show the certificate name.
Likewise on the Certificate record you would have an embedded report of all the Customer Certificates where you would show a column for the Customer name.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
