Resolving Many-to-Many Relationship

[canyonlight]

I am a volunteer at a food bank that helps needy folks, and I have - perhaps foolishly - also volunteered to help with getting the food bank out of the paper index card world and set up a helpful database.

I have two tables: "clients" and "visits." Both entities are related to each other on a many-to many basis. For each client there are many visits. And for each visit there are many clients.

I understand that I need to resolve this into a one-to-many relationship using a "join table." Can anybody suggest an attribute of both clients and visits that may assist?

Clients are visitors to the food bank and the table includes name, address, date of birth, etc. Visits are individual sessions when the food bank is open and the table includes name, date of visit, type of assistance, etc.

Thanks in advance for your patience and assistance with an obvious noob.

Stan

[comment]

The best attributes to use would be ClientID and VisitID - both auto-entered serial numbers in their respective tables. See a basic demo here:

http://www.fmforums.com/forum/showpost.php?post/246136/

[canyonlight]

Eureka! Thanks so much for your helpful example.

Stan