I would like to have a textbox/dropdown which selects a row from a linked table if the user enters the name of an existing entry, but if they enter a name that doesn't exist, the entry will be created in the linked table.
What is the most straightforward way of doing this?
HI,
Use filter on entity attribute select record 1 only if it is return that mean Exists otherwise create new record.
Regards
Rahul