I have 2 tables, Lets call them Table A and table B.
They have a relationship via a unique identifying number.
While in table view in table A I also want to see a field from table B. This field tells me if its a work in progress or its been approved.
However it only shows me the first record that relates to the unique ID.
I need FMP to look thru all the records that relate to that ID and show me if it has been approved, if not then leave the field blank.
Am I going about this wrong? Should I be looking into a formula?
Thanks in advance