Weird Happenings in Linked Tables, Relationships not Correct?

[Criki]

OK, I'm not new to SQL by any means (no expert either) but this is blowing my mind!
I have a 3rd party application that uses Access as it's database. We use SQL and have linked all our tables in Access to use this app.

Previously, there were 3 tables, tbl_parent, a child tbl_child, and a lookup table tbl_LU. This worked fine, but our rules changed so our structure changed.
Now we have tbl_parent, tbl_subParent, and tbl_LU really wasn't a lookup table so it became a parent of tbl_child (and a child of tbl_subparent).

All the data is there. There are no orphan records.
But for some reason some of the tbl_LU and/or tbl_Child do not show. Even after I verify they are in the db and all the related fields are completed and correct.

I haven't been able to find any rhyme or reason to why some show fine and others do not. The only thing I can think of, it must be an Access thing. When creating a view in SQL all records show fine, it's just in Access or the App that I have issues.

If anyone can shed any light on this I would greatly appreciate it. I know it's very vaugue, but that's why I can't solve it either.

Thanks SO much!

 

[PHV]

Does access recognize all the Primary Keys ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[willir]

I am confused on the wording...

All the data is there

How are you "seeing" the data?

tbl_LU and/or tbl_Child do not show

Show where?

...A leap
Are you talking about the fact that you can not see the tables in the Relations GUI tool???

If this is your problem, you can add the tables. Open the "Relationships" window. The click on the menu option "Relationships" -> "Show table" and add your missing tables.

Richard