MS Access: building db that reflects couples/partners

[Guest]

In buildnig a database for event attendees; at time of registration, how does
one go about linking two different AttendeeID's as one couple (that may or
may not differ come time to register for another class or business event?
Send to jean.ockert AT mindspring. Thanks.

 

[Guest]

Try setting up a couples table where you keep person ID for each partner and
the class they attended as a record. It's slightly redundant data, but it
simplifies a lot of reporting type questions downstream.