5 Replies Latest reply on Jan 4, 2010 8:40 AM by comment_1

    new record button on table a for table b

    househark

      Title

      new record button on table a for table b

      Post

      Hi, 

       

      FMP Pro 9

       

      I have the following (simplified):

       

      Table A (Order)

      Field-Table A ID

      Field-Table A Variable

       

      Table B (Report)

      Field-Table B ID

      Field-Table B Variable

      Field-Table A ID fk

       

      These tables are related from Table A ID - Table A ID fk. Each order can have many reports.

       

      I want to pull table A ID & Variable field on to table B. No problem just enter table A id in table A ID fk on table B.  However then user has to remember table A ID and enter it twice.

       

      My question:

       

      I want a button on table A that when pressed makes a new record on table B automatically inserting ID and Variable from record being browsed in table A.

       

      I have seen solutions such as:

      Set Variable

      Go to record

      Create New record

      Set Field

       

      It doesnt work.

       

      Any suggestions?