ACCESS FEED: [MS_AccessPros] form and subform question

Kamis, 25 September 2014

[MS_AccessPros] form and subform question

Hi John, thank you for getting back to me.
I do not think I explain you well, what I am trying to do.
I am using two different entities, but I do not think it makes a difference:
1. resorts - resortID = primary key
2. owners - ownerID = primary key
3. ownerresorts - linking table. ownerID and resortID = primary key
I can make a query and join these three tables.Then I can make a form base on it and the wizard creates a form and subform.
The form display the resort information
The subform displays the owners at that resort.
I am attaching the database, I do not know if you might have a chance to take a look.
What I wanted to do is similar to how you do the form and subforms in the advance section of the book, Access Inside Out.
In that example you build the querries, then the subform, form, and main form using your separate queries and then you link them together in the form properties.
So I thought it would work as follows:
1. Make query that gives me a list of owners.
2. Make a form base on it.
3. Make a query based on resorts and owner resort.
4. Make a form based on the query above
5. Embed the form from step to into the form from step 4
6. Set the link master fields and Link child field properties.
　
Is this the correct way of doing this?
In the sub form, I would like to include the owner ID as a combo box, that way I can ads owners to a resort.
----------

BUSINESSOFFICE

[Non-text portions of this message have been removed]