Join together values from different records (same field) 1

[straybullet]

I have a DB with tblCustomers and tblMVisited. (I added tblMVisited - the original designer had added fields to tblCustomers as needed. These values have been copied to tblCustomers with the CustID)

For each tblCustomers.CustID there are 0-3 (or more) entries in tblMVisited.

For each tblCustomer.CustID where there is an entry in tblMVisited, I'd like to be able to have a single textbox on frmCustomer show the entries in tblMVisited.

ex:
tblCustomer.CustID = 1
tblMVisited.intCust = 1 tblMVisited.strModel = WGW
tblMVisited.intCust = 1 tblMVisited.strModel = MLBK


tblCustomer.CustID = 2
tblMVisited.intCust = 2 tblMVisited.strModel = GV
tblMVisited.intCust = 2 tblMVisited.strModel = WGW
tblMVisited.intCust = 2 tblMVisited.strModel = ELD


desired in textbox on frmCustomer:

WGW/MLBK <-for CustID1
GV/WGW/ELD<-for CustID2


Each combination of tblMVisited.strModel and tblMVisited.intCust is unique (enforced by a dual primary key)

Is this even possible? I tried searching TT, but I have the feeling I was using the wrong terms...

Let them hate - so long as they fear... Lucius Accius

 

[lespaul]

I think you want FAQ701-4233.



Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for database developers:
The Fundamentals of Relational Database Design
Understanding SQL Joins

 

[straybullet]

TYVM! apparently, after all these years, Ive yet to spell concatenate consistently...

Let them hate - so long as they fear... Lucius Accius