Prevent Duplicate Records from Portal to Lineitem

[John Harris]

I have two databases providing data to a "line item" file. I have a portal in one file which enters data via a dropdown list. Is there anyway of checking that the "line item" record is unique.

I have tried creating a combined calculation field in the "line item" (name_id & event_id) and setting the validation as unique but that doesn't seem to work.

I have tried using a count and self join relationship, to enter "unique" or "duplicate" into another field, but not only does the combined field only contain data from the first field entered, it doesn't change when I edit the record. If I remove the data from the combined field and reenter either name_id or event_id it seems to sort itself out a bit. The same thing happens with the unique/duplicate field.

Any Ideas ?

[BobWeaver]

You might want to check out this topic:

http://www.fmforums.com/threads/showflat.php?Cat=&Board=UBB18&Number=49485&page=2&view=collapsed&sb=5&o=365&fpart=1

[stevie.at]

For the record:

I didn't try this in another FM Version but your 1st suggestion (creating a unique field by a calculation of both IDs in your bridge-file and set it to "unique" as Validation) works well in FM7. I use it in any portal that allows creation of records.