'SubTable' to manage items attached to a specific record

[RichardGR]

Hello,


I am trying to develop a database to record members at a sailing club, and I have stumbled across a small problem.

Each member has a boat, some more than one, attached to them and I want to explore the possibility of having a 'sub-table' inside the members table.

Here is how I am thinking it would go together:
Members are stored in table tblMembers
Boats are stored in table tblBoats
tblBoats and tblMembers are stored in _membershipdata.accdb

The data is then inputted and edited through forms in file _interface.accdb

Is anyone able to guide me on how to go about this please?

Thank you very much,
Richard

[June7]

Can each boat be associated with more than one member? If yes then use a third 'junction' table to associate members and boats. If no then just save the member ID in tblBoats.

You might want to use form/subform arrangement for data entry/edit http://office.microsoft.com/en-us/ac...010098674.aspx

[RichardGR]

Each boat can be associated with more than one member, however it is very unlikely that there will be circumstances when this occurs.

When you say to save the Member ID in tblBoats, how would I be able to do this in a way that meant that I could create new boats through a member editing form and it would automatically save so that whenever I open up that specific member, it only shows the option to create a new boat and also sees only the boats associated with that member?
Thanks,
Richard

[June7]

Use form/subform arrangement. Did you review the link I posted?

[RichardGR]

Thanks June, I've looked at the link - and it works perfectly now. The problem is now Solved.