Trouble with relationships
I have a question and I'm hoping that you guys can help me:
a) I have Table A, Table B and Table C.
b) I have looked up some text values from Table A into Table B via a relationship.
c) Based on the values I looked up in Table B (from Table A) and a few additional fields from Table B( which are text fields), I'm trying to create a relationship between Table B and Table C.
But this does not work! I have wasted lot of time to fix this but nothing worked. Please help!
BTW, I'm using FileMaker Pro 11 on a Mac.