Hi, Apologies if this has already been asked/answered or covered in a video. If so, please could you inform me of where it can be found.
I have a form in which users(requesters) can input their name, i have it as a dropdown list the data of which is sourced from a table called RequesterInfo. This dropdown list doesn't force them to enter a name on the table so a new requester can still use it. Is there a way for me to have a new requesters name get transferred to the table? i.e. if my table only has Mark, Henry and Luke in, they will be the only ones appearing in the dropdown, but if Bruce makes a request his name doesn't get added to the dropdown list; presumably because he hasnt been added to the RequesterInfo table.

For reference the this form is bound to a table called SampleSubmission, i have gone in and amended the RequesterName field to link to RequesterInfo table.

If you required any further information regarding my issue/query please let me know.

Kind regards,
Ben