linked tables not linked in the front end!

[DowningDevelopments]

Hello everyone,

ive got my test database split into a database1_be and a database1_te file.
Ive had this arrangement for many months and not had a problem till this week.

I added a tables called StudentLetters and i wish to tie to my students
table. I created and then linked (one to many) in the backend using the
relationships chart. Everything is fine upto this point.
Once i go to the front end and i link to this table i find that the chart
does not show the one to many link. So i manually link them here and instead
of showing the same result as the back end an indeterminate link is created.

why arent my links being shown correctly? and ive noticed that some of my
other tables arent linked in the frontend the way they are in the backend.

Any help will be appreciated.

Amit

 

[Rick Brandt]

Hello everyone,

ive got my test database split into a database1_be and a database1_te file.
Ive had this arrangement for many months and not had a problem till this week.

I added a tables called StudentLetters and i wish to tie to my students
table. I created and then linked (one to many) in the backend using the
relationships chart. Everything is fine upto this point.
Once i go to the front end and i link to this table i find that the chart
does not show the one to many link. So i manually link them here and instead
of showing the same result as the back end an indeterminate link is created.

why arent my links being shown correctly? and ive noticed that some of my
other tables arent linked in the frontend the way they are in the backend.

Relationships only matter in the back end. In the front end they are just lines
on the screen. About the only functional thing they do is to automatically add
join lines between tables when you create new queries.

Personally I wouldn't worry about it.

 

[DowningDevelopments]

ok then, thats fine, i was only worried cos my other tables show the
relationships too and this one wasnt!