Richard,

I found the answer to the question that I asked you yesterday!  The tables are related in the property sheet of the child form with the “Link Master Fields” = GuestID & “Link Child Fields” = GuestID.

So it seems that there is three ways to relate tables to one to another:
1. Hardwire the tables in the Relationship window.
2. Use a query to build a relationship with tables.
3. Use forms to relate tables using the Master & Child Links.

Thanks for your time. Gary Morrison

---

Reply from Richard Rost:

Doesn't it feel great to solve your own problem? I love it. Congratulations. I answered your previous question not seeing this message. Anyhow, you'll notice that when you have your relationships set up beforehand, Access just automatically places those field values in the Master and Child properties for you.