If record with key field exists don't create another one through a relationship
I want to make choose a section name from the table SectionSow_Section through a relationship with the table Scheme of Work.
The tables match through SectionSow_SECTION::Section and SchemeOfWork::Section. The SECTION table also has another relationship with the SchemeOfWork table through their key fields which use look up to match the serial numbers.
In most cases the section already exists. I have a drop down list that auto completes as I fill it in. So when I create a new record in SchemeOfWork and fill in the Section field with a previously entered name I expected that the previous record would be called up. But I'm noticing that a new record is being made. A new serial number shows up in SectionSow_Section::SectionID until I commit the record by moving to a new field. Then the serial number of the first SectionSow_Section::SectionID shows up.
How can I stop the creation of new records if one already exists?