Form_ID Sequence

Hi,

We currently have two contact forms running for a project we are working on

https://www.colgatecommunication.co.uk/colgate-total-pep-dental-professional-sign-up/

https://www.colgatecommunication.co.uk/colgate-total-pep-patient-sign-up/

Once people have entered their data we have two separate database’s. When we export the data we have the fields present on the form and we also have

Form_id Form_date Status

What I am trying to achieve is that the Form_ID number can start from 1 and continue sequentially without entries from other forms affecting it. At the moment if someone signs up to another form, the id will continue so if someone signs on form A they are number 1 if someone signs up on form b they are number 2, then if someone signs up again on form a they are number 3.

Also is it possible for the ID to start at a specific number other than 1, ie 1000

Hope this makes sense

The page I need help with: [log in to see the link]