When a company log into the member site there is a form button where I am asking them to fill in the form. This form is linked to the database (standard form for all the businesses) whenever they update this form data I want the database to be updated too but without a unique reference the database would not know if it’s a new submission or and existing one that the record needs updating.
Any help will be much appreciated.
I have a standard form for all companies to fill in once they have logged into the member site.
Somehow I would like to put a unique ref to link to the database record per company so that any update made on the form is linked to the relevant record on the database.
Example:
Say the form has three field
Manager Name, Turnover, No. of staff
Company A submit this information (Manager Name, Turnover and No of staff when they first sign up. Then after 1 year a new person join the company this information is updated . I would like the same record on the database to be updated instead of a new record on the database. I guess I would need to somehow link the database to this form but how is the question.
Any help will be much appreciated.