Access 2007 table relationships & queries

[cath_hopes]

Hello again!
I've set up a simple query using 2 tables, however the query relationship is not 1 to many as it is under the table structure. Is this a Access 2007 bug or have I missed something? I've based a form on this query and it seems to work ok so at present this is more of a curiosity question than an urgent need to know. Thanks for reading.

[mattj]

I really don't understand what you mean by the relationship is not 1 to many as it is in the table. How do you know that it isn't 1:M?

Matt

[cath_hopes]

Maybe it is, its just that in the design view of the query I was expecting to see the line linking the two tables displayed as two boxes with an infinity symbol on one side, just as the relationship diagram diagram shows, but the infinity symbol is missing. Maybe its an Access 2007 bug?

[mattj]

Do you have referential integrity enforced? The symbols will only appear when RI is enabled.

Matt

[cath_hopes]

Yes, RI is enforced.