Linking Data on 2 fields.

[ashley25]

I have a table of data with customer id, visit ref, reason for visit, type of visit and other stuff.

I then have various support queries that group customers based on reason for visit, type of visit etc. I need to be able to link this to my main table so that each customer has a category against them.

The issue I have is that some customers will have more than one visit ref, which can also mean they have multiple reason for visits. I need to make sure that when I link my queries back to the main table that the right category appears against the customer and their correct visit ref.

So I need to be able link my customer id and visit ref at the same time.

Does this make sense and can someone help?

 

[GinaWhipp]

Sounds like you are missing a junction table... tblCustomerVisits which would enable you to see multiple visits for each Customer. Is that the problem?