Search related fields for Duplicate
I have a related field that has a dropdown where you can search as typical (probably 30,000 records) for a particularly entry number (number is really an alpha numeric code). If the record the user wa...
Forum Discussion
Is the Entry Number the key field for the related table? If so, you can build another relationship (exactly like you already have), but then change the new 'Related Entry Number' field to a formula field that references the 'Enter New Entry Number' field. You'd want to have some lookup value for this new relationship - probably Record ID# - and then you can set a form rule to 'Abort Save' if there is something in the entry field and there is no value in the lookup field.
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
That's a brilliant idea. Going to do that right now.
------------------------------
Mike Tamoush
------------------------------
------------------------------
Mike Tamoush
------------------------------