Submission Form - Multiple entries

[jakeindigo]

Hi, 

Is it possible to create a submission form wherby I can add multiple entries per each field and these be associated with another set of inputted values?

For example I would like a member of staff to be able to input costs related to a job in a field like below:

Job ID:
 1

Job Title :
Corporate hire event

Costs :
Cost 1 name
Cost 2 name
Cost 3 name

Cost Value :
Cost 1 value
Cost 2 Value
Cost 3 value
 

[MayMusic]

For each entry you need to have one field in the table, if the number of costs is not fixed for each field, then you need to create a table for value and cost with the Job ID with it. For instance the  following tables:

1: Job Table: Job_ID (unique), Name, Value

2: Cost Table: Job_ID, Name, Value

 

So for each row in Job Table there can be multiple rows in Cost Table