Form with relational data

[AllegraAccess]

I am very new to Access. I have very familiar with MySQL and PHP. I am trying to build a db that has a MemberT table, a WineT table and a MemberWineT table. Each member is to be assigned wine(s) from the WineT when the Member is entered via a form. The WineT has a wine "class" which is "Red" or "White" and the "type" like "Rich & Creamy". To connect the member to their wine the MemberWineT stores the MemberID with the WineID, at least that is the plan. I can't quite figure it out how to create a form that allows me to enter the member info and their wine choices. I have relationships setup where the MemberT's MemberID is linked to the MemberWineT MemberID and the WinesT is linked to the MemberWineT WineID. I have queries to list only the wines in red class and another to list only white wine class.

[pbaldy]

I would think a form bound to the member table and a subform bound to the junction table. The master/child links would keep the subform in sync with the main form.

[AllegraAccess]

I would think a form bound to the member table and a subform bound to the junction table. The master/child links would keep the subform in sync with the main form.

On my members form I have a combo box that list the wines. When someone is entering a new member they need to be able to select the wines (more than one) types the member wants. When I create the combo box it ask me where to get the data from and I select the wine table. Then I set it up as far as sorting etc., but at the end it asked me where I want to store this data. Want this data to go to the MemberWineT table (his table has the MemberJID and the WineJID), but it only shows the MemberJID as an option, but I want to save it to the WineJID. Beyond that I can't figure out how to get the Autonumber Member ID to go the the MemberJID when the record is being created.

[AllegraAccess]

I figured it out. I needed create a form from my MemberWineT.

[pbaldy]

Glad you figured it out, and welcome to the site by the way!

[AllegraAccess]

I am getting there, but I have another question. I would search, but I am not sure even how to ask it. On this form I want to list in a combo box all the wines the member has been assigned already. I have created a query from my relationships of my tables that show the member and their wine. Where I am having a problems is the criteria has to be where the MemberJID = MemberID (I have 5 in my image for an example) that is selected in the form. So I know I have to create a code that onChange of the Member field will tell the Member's Wine Comb box to load the query where MemberJID equals the MemberID of the Member field.

[pbaldy]

Sorry, I lost track of this thread. Did you get it sorted out?