relationship problem

A

anil

hi
i have relationship between tblsites and tbllabdata in one to many.Now
i rename tbllabdata into tbllabResult.In relationship window it shows
the changed name,but when i click at + sign on tblsites(site_Code) it
says unable to find tbllabdata.i have saved everywhere.also removed all
relationship and add new one but no sucess.
can someone help where is the mistake
anil
 
G

George

Hello there,

Assuming that you have re-built the relationships using the new table name:
Open your table and from the Insert menu select Subdatasheet and select the
newtable.

George

Ο χÏήστης "anil" έγγÏαψε:
 
J

John Vinson

hi
i have relationship between tblsites and tbllabdata in one to many.Now
i rename tbllabdata into tbllabResult.In relationship window it shows
the changed name,but when i click at + sign on tblsites(site_Code) it
says unable to find tbllabdata.i have saved everywhere.also removed all
relationship and add new one but no sucess.
can someone help where is the mistake
anil
Click to expand...

View the properties of tblSites. It probably has tbllabdata in its
Subdatasheet property. I'd suggest avoiding using subdatasheets AT
ALL, they can severely slow down your database and they're not
necessary if you use Forms with Subforms for your data entry; change
the Subdatasheet property to [None].

John W. Vinson[MVP]
 
A

anil

thanks john and goerge.
it helped a lot.i just forget the thing and was too confused in
problem.
thanks again
anil
 
Top