Relationships not related

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an access database with several tables. For the purposes of this
question, let's say there are 3 tables named Table1, Table2, and Table3 and
they have one-to-one relationships via a primary key (call it ID), although
Table1 is kind of the "primary" table. The problem is that, while the tables
nominally have relationships, in practice the relevant records in the related
tables are not consistenty available. For example, when viewing Table1, only
Table2 is linked, while when viewing Table2 both Tables 1 and 3 are linked.
When viewing Table3, neither 1 nor 2 are available. Maybe I misunderstand
how this whole thing works, but I expected that if they're all linked then
they'll all be linked all the time.
 
How can you tell that when you view Table1 only Table2 is linked, etc.?
 
Je'farc said:
I have an access database with several tables. For the purposes of this
question, let's say there are 3 tables named Table1, Table2, and Table3 and
they have one-to-one relationships via a primary key (call it ID), although
Table1 is kind of the "primary" table. The problem is that, while the tables
nominally have relationships, in practice the relevant records in the related
tables are not consistenty available. For example, when viewing Table1, only
Table2 is linked, while when viewing Table2 both Tables 1 and 3 are linked.
When viewing Table3, neither 1 nor 2 are available. Maybe I misunderstand
how this whole thing works, but I expected that if they're all linked then
they'll all be linked all the time.
Click to expand...

Je'Farc,

I am not at all sure what you meant by "records not consistently available". When you run
a query, one set of records are displayed, and when you execute the query again moments
later with no changes of any kind (including no changes in variables or times), a
different set of data is displayed?

Also, I am not sure what is meant by "when viewing Table1, only Table2 is linked [...]"
etc. What is meant by "viewing" and what is meant by "linked". You can't be talking
about table datasheet view, because then only one table is involved. "linked" can refer
to MS Access Relationship object or query JOINs. Are you referring to query datasheet
view? A query written where there is only a JOIN between Table1 and Table2?

1 -- Please provide the relevant portions of the table structures: including column names
and data types, plus the keys and indexes, for all tables involved.
2 -- Please provide the SQL of all queries involved (Menu: View > SQL View).
3 -- Please provide relevant sample data from the tables involved, in comma delimited rows
(20 rows max).
4 -- Please provide a sample chart of incorrect results, in comma delimited rows (20 rows
max).
5 -- Please provide a sample chart of the desired results, in comma delimited rows (20
rows max).
6 -- If the above requests do not make sense, please ask specific questions about them.


Sincerely,

Chris O.
 
Many thanks for your offers to help. I will try to clarify the issue under
the later thread "More than two related tables seems to affect all
relationships." (I inadvertently posted twice).
 
Back
Top