relationship problem

[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

 

[Guest]

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" έγγÏαψε:

 

[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

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]

 

[anil]

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