Hi, I have what is probably a very basic problem to most of you. I am having a very difficult time wrapping my head around this whole relationship thing. Here's my problem...

I have 3 tables and they all have one ID field that is the same in all 3 tables. So in the relationships graph I indicated that the ID field in Table A is the same in table B. And that the ID field in Table B is the same in Table C. This works fine when I have a field in table B looking up information on Table A. But I run into problems when I add a field in table C looking up information on table A. I can't understand where I went wrong. I've added an example of what I'm talking about so you can see it visually.

I'm using FM 8 on a Mac. I'd appreciate any help and clarification you can offer.

Thank you!

kallain

Example.fp8.zip

If you are using "4" in table C then because there is no "4" in table B, it will not display the table A data.

Thank you for your reply.

Ok, I think this is starting to make sense... The way I'm understanding it is that the data won't show up unless the matching field in the directly connected table is the same. Right?

How can I avoid this? Should I create a second instance of table A and table C on the relationship graph and link them directly?

Thanks for your help.

You can just add a new Table Occurence of Table A connecting to Table C. Then you can reference the field from that new occurence.

I would suggest you read up on relationships and also take a look at the whitepaper linked in my signature file.