Table/Relationship Problem?

[WallbrownF]

Hello everyone! I'm not sure how to word this, but I have a picture! I'm pretty new to Access, so please forgive me. I have a main table that I'm working with and a subordinate table under that and then two subordinate tables to that one. Now, when I go to expand the first subordinate table...it references back to itself. Now, I've checked the relationships and they seem to be fine. I even deleted them all and redid them. Now, I do know that this message popped up when I was doing all of this and it asked me something about tables and relationships, but I don't remember what exactly. Please help. Thanks in advance.

[orange]

Perhaps you could repeat the steps and record what messages you got. It's pretty hard for the rest of us to guess what you did, and what errors you received.
You're going to have to give more info if you want a meaningful response.

[WallbrownF]

It was worth a shot...

[WallbrownF]

Okay...So, I exported the access files to excel files then back again (I figured this would clears some stuff). Then, I recreated the relationships. I think you can see what I'm trying to do.

[WallbrownF]

[WallbrownF]

Okay...I got the Interval ID to expand to the Description Table, but is there a way to have it expand to two tables? I would also like to have the interval IDs expand to the Blow Counts as well. They are both skinny tables...or does that matter?

[WallbrownF]

I got it to where the Blow Count can expand off of the Sample Descriptions. So...If someone knows how to get the Data Table to expand to two subtables...that would be great.

[orange]

You know your application very well. The rest of us don't.

What does this mean, if you were to explain it to a stranger

If someone knows how to get the Data Table to expand to two subtables...that would be great.

Do you think you could explain your application to us, at this level? Our business is
... I have these tables..... and I'm trying to....

I think you have a relationships issue, but that also is a guess.