Default Value for Lookup

I have a table “Demo” that has a column “Status” which is a lookup into another Table “Status.Status” . I want to set a default value for Demo.Status to “Ordered” which is one of the values in the lookup table.

How do I achieve this in the default formula?

You can reference the status directly using @. See if this helps you:


Thanks that’s got it for me.