How to collect data for single unique ID with several forms?

i want to create a form for demographic data. 

The structure is this:

employer name address etc keyed to

employee name and demographic data. Multiple employees to one employer)

So there is a one to many relationship. 

Ideally they entere the employer

and they add each employee row until done and than submit so each employee is keyed to employer ID. 

This will than than goto a Azure SQL database. 

Is the above possible?

Thanks. 

David 

In case you need this I would use the HIPPA compliant tier as I may want to create forms for my dental office. The above question is for our professional organization. 

Hello David,

Unfortunately, I am not sure if I understand the idea in full. Do you want to collect the data with single form or with several ones? Could you please provide a bit more information?

If you would like to allow your users adding new sets of fields for the list of employees, you could use Configurable List widget: How-to-Set-Up-the-Configurable-List-Widget

We will wait for your reply. 

In essence, I need to have it like this.
Unique Employer ID (assigned by form)Employer name, address
Employer ID,last name ,first,etc
There are multiple lines for employees.
But each entry will have the unique employer ID
So in the end the form saves to two SQL tables:
Employer Table
Employee Table
These are related by Employer ID
The second part was if on a form they can start new row so if there were 3 employees they add a line each time for the next employee.
Hope this helps!
Thanks
David
________________________________
...

I see this implementable if you combine 2 forms. Let's say, first form is collecting information of employers, generates ID for them if needed. After this form is completed, respondent is redirected to next form automatically, where they can enter employees info: Redirecting-Users-to-a-Different-Page

Unique ID can be passed into second form to keep track of submissions: How-to-Automatically-Pass-Form-Data-to-Another-Form

Would this work for you?

 

Hi,
That may work. I will look at over Thanksgiving break.
David
________________________________
...