Hi Charles,
IF Field definitely solves the problem of having 2 different autofill records depending on the [machine lay] / [hand lay] options within the form.

I should've explained what I would like to be inserted in the autofill field.

If [machine lay] is chosen then I would like it to insert a list format of machinery needed to complete a job. Same with [hand lay] but it would list less machinery.

For example:
[machine lay]
Paver
Roller
Chipper
Deadweights

There will probably be a maximum of 6 items to list. Should I insert an autofill field for each item and have them reference the IF field to include the correct items dependant on the primary option?

Thank you for your help. It is definitely the start I need to get the ball rolling with this function.