Skip to main content

Joined Field as Primary Field in New Table

  • November 6, 2018
  • 2 replies
  • 27 views
S
Forum|alt.badge.img+3

Hi-

Is want to concatenate the two values in one table into a cell in the same table, and then use that combination as the primary field in another table.

The first cell is equipment type, and the second field is test type, and I want to record test results that are unique to the combination of the two.

Any ideas? Thanks.

      This topic has been closed for replies.

      2 replies

      E
      Forum|alt.badge.img+17

      You can you use a Formula for that.

      You can:

      • Create a Lookup to bring the combined fields mentioned before (of course you need a Linked Record field and relate to a Table A record).
      • Set the primary field to be a Formula with just the previous field.
      S
      Forum|alt.badge.img+3
      • Scott_Schmidt
      • Author
      • New Participant
      • November 7, 2018

      You can you use a Formula for that.

      You can:

      • Create a Lookup to bring the combined fields mentioned before (of course you need a Linked Record field and relate to a Table A record).
      • Set the primary field to be a Formula with just the previous field.

      Thanks for the help. Works great!

      Scott.

      Terms & ConditionsAccessibility statement