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