Relationship Between Tables

[Lloydy-Lee]

Hi,

I've set up a relationship between tables, however when i click on the cross
to expand the record and see the linked table I get this message. It now
wont reverse. Please help.

The table or query name 'Sheet1' you entered in either the property sheet or
the macro is misspelled or refers to a table or query that does not exist.

There is no table or query named Sheet1.

Thanks in advnace for your help
J

 

[Allen Browne]

Open your table in design view.
Open the Properties box.
Set the SubdatasheetName property to: [None]
Save. Close.

That should remove the bad association. The little + at the left of the
datasheet should be gone completely. Once you have solved it, if you want it
back, you can go back into table design and set the Property to [Auto].

If the problem comes back at this point, then Name AutoCorrect would be the
most like culprit. Here's some more info about that and how to clear it:
http://allenbrowne.com/bug-03.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.


news:[email protected]...