3 Replies Latest reply on Oct 22, 2013 2:31 PM by lauriehughes

    table relationships



      table relationships


           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