Adding a row to a referenced table

The Name field of the form is referenced to a staff directory table so that when a user fills out the form they can select his or her name. There are times when a user who is filling out the form cannot find his name because the directory table hasn’t been updated yet. As a result, the user cannot submit the form because the Name field is left blank.

What’s the best way to resolve this?

Is it possible to allow a user to add her name to the table somehow? In other words, I would like a user to be able to update the staff directory table (adding his name) in case their name does not come in the drop-down menu.

Typically the user should be able to see the “Add” button to add a new name in the referenced column if she /he wishes to add a new name. When the drop down appears for the referenced name column in the form , it should typically have the “Add” option.

Thanks for your reply, @Suvrutt_Gurjar . What if Add button is not visible?

Nevermind! I’ve figured out how to add this function.

1 Like