Hi

Here is my scenario.

I have two forms. One form is called Airstrip Profile. Thats the form we INITIALLY entered data and we have about 50 records to date. Recently I have imported a Excel file and as a Form with data and called it Rural Airstrips. Its has about 600 records.

 

Common fields in both forms (Airstrip Profile and Rural Airstrips) are: Airstrip_Name, Lat, Long. The Rural Airstrips has a dropdown field with 2 options. The 2 dropdown options are 'Verified' and 'Not Verified'

Now I would like to copy the record from Rural Airstrips into Airstrip Profile. If the user selects 'Verified', this sequence must happen:

1) Check if there is a record with the same airstrip name in Airstrip Profile. If so it should just insert data into fields missing in Airstrip Profile fields instead of creating a duplicate copy

2) If no record exists in Airstrip Profile then the record from Rural Airstrips to be copied across

3) If user selects 'Not Verified' then the system should remove the record with same Airstrip Name in Airstrip Profile

The idea is to only have verified data in airstrip Profile. Hope this is clear and some can assist.