I'm battling to get my head around my data structure and would appreciate some help.
I have two main tables - Customers and Groups. Each Customer belongs to a Group. That is the easy part. Fields within Groups include: "Host" and "Possible Hosts". Within the Customer table are two fields: "Able to Host" and "Venue Approved". If both fields are "Yes", I would like to add the Customer to the list of "Possible Hosts" for the "Group" he belongs to. Ideally this "Possible Hosts" field is a combination of the Customer's Name and Address. Then finally the "Host" for the "Group" needs to be selected out of the list of "Possible Hosts" associated with that Group.
I am not to sure how to go about setting this up. So I have a series of connections between Customer and Groups, or do I need to set up additional tables? And then how do I get a dropdown to show just the "Possible Hosts" for a particular group?
If you can make sense of the above, I would really appreciate some help.