Blank Cells in Query

[alanij]

I have a silly question but it's bugging the hell out of me!

I have run a query from 2 tables with a 1 to many relationship. My query shows what i want it to show but where there are duplicate records in my main table it leaves the cells blank where there are other records in my second table.

even though this data is the same I want it to appear in my query.

If this makes any sense is there any way of showing this?



thanks

 

[Edgarr8]

Do you have a unique ID for every record in your main table?

 

[alanij]

Yes i do. I have an autonumber field PK which is linked to the other table with a one to many relationship.

 

[neileg]

I would expect the main table to be the one side and your second table to be the many side. How can you have duplicate data in your main table?

 

[Edgarr8]

If you have doplicate data in your first table connecting to your second table, wouldnt it be a many to many relationship? Are you able to enforce Integrity rules?