Set value of new or existing record from a value on an open form from another table

I would like to do the following:

  1. Open a form named “ServiceLog 2” (new or exiting record)

  2. Click on an inline behavior action to open another view “Expenses” and the KEY column use the value from the KEY column of the record being viewed on the open form “ServiceLog 2”. When done with the view “Expenses”, return to the open form “ServiceLog 2”.

  3. Solved

  4. Needs solving

Solved Solved
0 13 333
1 ACCEPTED SOLUTION

  • Add a ServiceLog column (physical) to the Expenses table.
  • Regenerate the column structure.
  • Expand the column structure
  • Set the column type to REF, choose Service Log table and turn on isPartOf property.
    Save the editor. When you create a ServiceLog record, you can create as many as Expense records and it will always return back to the ServiceLog form.

View solution in original post

13 REPLIES 13
Top Labels in this Space