I have two tables, one has a list of services (Services) and one has customer info (Customer). Both customers and Services will grow over time. I would like to create a table which I can track which service each client has.
My thought is create a new table (tblTest). the first field would be a lookup of Customer Name. The remainding fields should be the ServiceNames listed horizontally (qryServiceName). I would like each of these fields to be yes/no boxes to signify that that client has that service. As new services are added, they would need to add to the field heading running horizontally.
Any help on this would be extremely helpfull. Thank you in advance.