database relationships

[graham menzies-kitchin]

On my table I have a + sign implying a relationship. When I click the + I
get the same row up as the open table and another + and so on 7 times.
Opened up relationship window, called for all tables and queries and no
relationships are shown.
I have done something stupid somewhere but am unable correct it.
Can anyone a) tell me what I have done, and b) more important, how to
correct it?

many thanks
Graham

 

[Allen Browne]

Open the table in design view.
Open the Properties box (View menu).
Set the SubDatasheetName property.

If your application works through forms like a good Access appllication
should, the most efficient solution is to set this property to:
[None]
so it has no subdatasheets.

 

[graham menzies-kitchin]

for Allen Browne
Brilliant - works a treat.
I had looked at Properties but could see anything obvious.
many thanks graham