Relationship changes when creating query

[lana]

Hi there,
Happy new year to all.

I have an existing program which works fine in one laptop which has Access 2007. When I install this on another laptop with Access 2007 then this happens :
in one of my query, the one-many relationship becomes a single line.!!!

Any help would be appreciated.
Cheers
LANA

 

[Ranman256]

the relationship should not change.
Is this a split db?
is the backend Access?

 

[lana]

Thanks for the reply.

My tables are linked to the interface program. The program is written by Access.
This works fine in one 2007 but not working in another. !!!

 

[Mark_]

@lana,

Can you please verify what data the second machine is looking at? i.e. is it the back end you expect? And have you verified that there would be more than one record that matches the criteria in the query you reference?

If so, can you please put up a sample database that exhibits the same issue? I've a feeling that the second laptop isn't looking at what you think it is looking at, hence the different results in your query.

 

[Ranman256]

what is the backend? Access tables?
normally, the relationship is in the backend, and the front end inherits it.

 

[The_Doc_Man]

Good call, Ranman. I've seen this behavior a couple of times (usually when I was a bit foggier than normal) in which I established a relationship between two tables in the BE but then, due to a hectic development schedule, forgot I did that. I later put the wrong relation type in the FE.

Sure enough, when I next opened that DB, the FE relationship got "corrected." The BE relationship always wins. So I can verify that your explanation might well be the case because I have seen it happen.

 

[lana]

Thank you all for your reply.
The whole program is written in Access.
Originally I wrote this program in Access 2003 which works fine without any problem.
Today I installed it in two different computers, both having access2007. It works fine in one but does not in the other.
I attached two pictures. You can see that the relationship in tables are correct. but in the query one of the one-many relationship changes to single line.
Thanks again.
Lana

 

[lana]

Thank you for your explanations.

I always used the logic you explained and never had a problem.
I created the table relationship before I created the query.

Is there any options I have to check or uncheck in "Access Options" section in 2007?
Thanks
LANA

 

[lana]

Thanks for your help.