RE: Using multiple 1 to 1 relationships

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I don't have the answer but a few hopefully useful thoughts.

Regarding capabilities of Access, this is at the rudimentary level. There
is a problem that needs to be found and fixed, not a limitation of the
software.

I find that when you get it narrowed down and it doesn't make sense , it's
time to recheck one's assumptions and observations.

One observation (or deduction from an observation) that you describe is
nearly impossible and thus probably erroneous. That is that you saved a
record in TermInfo and then somehow working with OTHER tables in a view query
modified the contents of a (FK field in) a saved record in TermInfo.

Make sure your experimental query is displaying the fields on both sides of
each join.

If you have "enforce referential integrity" turned on, try turning it off
during your experimentation.

In your second post you didn't describe / confirm your join types. I'd
confirm that both joins are the type that "shows ALL records in StudentMain"
and matching records in the child tables.

If you have further posts, you may want to clarify a few ambiguous areas in
your description. You keep saying just "failure" without saying what the
error message is. And you keep saying "the record" as if it somehow defines
where you are going in an output line of a query which is a compilation of
three records.
.

Relevant Pages

  • Re: Parameters in queries
    ... I believe that is exactly what I am saying, ... the 2nd query should use todays date instead of the parameter. ... ie both queries should use the same subquery not 2 separate ... WHERE BBIdentifier Not In (SELECT BBIdentifier ...
    (microsoft.public.access.formscoding)
  • Re: One-To-One Relationships
    ... Of course it isn't easy to query; ... I'm just saying I may not yet have ... don't exist outside of their attributes, good (that was a painful one ... Understanding the impact that object containment has on ...
    (comp.databases.theory)
  • Re: A new proof of the superiority of set oriented approaches: numerical/time serie linear interpola
    ... If we were in a procedural language, Cimode would be saying ... Selzer is arguing that the complexity of one query can be higher than ...
    (comp.databases.theory)
  • Re: Halt code execution until requery is finished.
    ... Are you saying that a "totals" query would execute completely before ... That's pretty much what I'm saying. ... regardless of the state of the calculations in the ...
    (microsoft.public.access.formscoding)
  • Re: Query does not display all records
    ... When I run the query it only diplays those records ... they have in common. ... I have tried all three join types. ...
    (microsoft.public.access.gettingstarted)