database relationships

  • Thread starter graham menzies-kitchin
  • Start date
G

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
 
A

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.
 
G

graham menzies-kitchin

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