How do I create a form that populates some of the fields from another table?

How do I create a form that populates some of the fields from another table?

I am trying to gather addresses for all people that will be attending an event. What I want to do is be able to send people that are helping me to an online form. The online form will have the names of people populated in the name fields that it picks from another table where they do not as of yet have their addresses filled in. Then, the person helping me, just fills in the address for that person and submits it. Once it is submitted, their name will no longer show up on the online form.

How could I accomplish this? Any direction you can give me is appreciated. I am trying to create a data gathering solution that is not like a spreadsheet layout.

I hope this makes sense. If not, please let me know.

Sincerely,

dan