0

How do you set a linked field to a specific record?

I've created a table (Currencies) with all the Global currencies, and linked that table to an Order table and I want to set the default linked record to be USD. I'm unsure how to trigger an update so that the record which is initially set is to USD.

The record number for USD in my Currencies table is ID# 146

3 replies

null
    • Fred
    • 3 mths ago
    • Reported - view

    Can you be a bit more descriptive of the flow? The table name, names/kind of fields that you are working with. Etc.

    • checkyourmirrors
    • Matthew_Moran
    • 3 mths ago
    • Reported - view

    Sure Fred,

    The Currency Table has three fields Currency text field (USD, GBP, etc) and Currency_Name text field (US dollar) and last a number field for Sort Order.

    I am looking to have the linked record be pre-populated with the record for USD (ID# 146).

    • checkyourmirrors
    • Matthew_Moran
    • 3 mths ago
    • Reported - view

    I tried using the below which does populate the field but the challenge and it seems to work fine.

    Currencies := record(Currencies,146)