Subforms & Data Replication

[Guest]

I am using a form with a subform, and need to apply a button to enable me to
add a new instance within a Record.

eg. Person a has had 4 jobs previously, so I would need to click on the
'button' to add each instance of that job. because at the moment the subform
adds the data as though it belongs to a new record, thus making the dataset
highly duplified.

 

[Guest]

Hi Richard
If you have records wher this situation is comman then you can creat a new
tabel name it appropriately and than have ID of the first tabel in the second
tabel and that fields linked . then you can base your subform on the new
table and now you can add as many new records as you want without making
duplicate records.
You will have to make some changes in the subform. ie you will have to add
the field that is command in both of the fields and then you will have to
link master field and chield fields with that command field so you can see
the all the related records .