Access query - mulitple rows in record

[Dartagnan]

Background
Table A - a list of applications
Columns = ID - tblName - tblDescription

Table B - List of contacts
Columns = ID - tblContact

Table C - Combines data from A and B as follows.
ID - tblapplicationsid - tblcontactsid

Query columns = ID - tblapplicationsid - tblcontactsid - tblcontact

When I query table C and bring in table B to see the contact name the tblContact keeps returning multiple rows but in one record. Let me clarify this. The query returns only 2 records. When I click to enter the tblcontact column for the 2nd record I am able to scroll through 3 additional rows. I have verified I should only get the 2 records returned. I am unable to determine why the tblcontact column, for record 2, shows multiple rows.

Any help is appreciated.

 

[boblarson]

Sounds like you are on Access 2007 or above and are using a multi-valued field. Is that true?

 

[Dartagnan]

Actually I am still on Access 2002. Could there be a caching issue or corruption?

 

[boblarson]

Actually I am still on Access 2002. Could there be a caching issue or corruption?

No probably just a communication error as I'm not picturing exactly what you stated.

So, I'm thinking that, if you want to, you could post a copy of your database (with bogus data) here at this other forum where I'm a super moderator and which allows uploads of zipped database files (where this one does not) and I can take an actual look at what you have to see what it is you're trying to explain. But it is up to you. I don't normally like to have someone move between forums but sometimes being able to upload a file makes it much easier to diagnose the problem.

 

[Dartagnan]

Not able to start a new thread on that site. I am in the Access FAQs section.

 

[boblarson]

Not able to start a new thread on that site. I am in the Access FAQs section.

That is a moderator post only category. Go to the General category.