I am setting up event mgmt DB and need help on how 1 contact can have multiple event registrations?
If I want to set up my database so one contact can register for several events how do I do it so that I do not duplicate my contact? I am using Filemaker Pro 11. I have set up 3 tables, one listing all my contacts, one with all the registration data fields (info that i want to capture relating specifically to their registration, not to their contact details ie registration fee and one which lists the different events. Have I done this correctly? I suppose it is like someone buying a product you need contact details for person, product information and purchasing/invoicing information. The question is how does the database show one person buy multiple products? Please help...