AnsweredAssumed Answered

table relationships

Question asked by lauriehughes on Oct 21, 2013
Latest reply on Oct 22, 2013 by lauriehughes


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