Hello,
I am creating a small db to manage member of a sports club.
I have a two main tables: Members and YearlyFees
Memebers is to store general info.
Yearlyfees is to add the yearly fee each member pays.
The unique code for both tables is ID.
I first add a new memeber, than save the record to the table Memebers. A small line of code will also save the ID to the table Memberfees.
To update a record I double click on the list box.
When I open the form, I would like to show a subform to add the yearly fees that each member pays yearly, but cannot find a solution.
Posting a sample file. Thank you for your help.
I am creating a small db to manage member of a sports club.
I have a two main tables: Members and YearlyFees
Memebers is to store general info.
Yearlyfees is to add the yearly fee each member pays.
The unique code for both tables is ID.
I first add a new memeber, than save the record to the table Memebers. A small line of code will also save the ID to the table Memberfees.
To update a record I double click on the list box.
When I open the form, I would like to show a subform to add the yearly fees that each member pays yearly, but cannot find a solution.
Posting a sample file. Thank you for your help.