Posting to an index table

[Chris Kay]

I am using Access in Microsoft Office 365 to create a database of sailing club members and their boats.

Members-Table hold the details of each member and these details are entered and edited using a form Members Edit.

On the Members Edit form there is a command button ENTER NEW BOAT. On pressing this button a form New Boat is opened allowing you to enter details of a new boat onto the Boats-Table.

When closing the form New Boat I wish to use the Boat ID of the newly created record in the Boats Table and the Member ID on the already open Members Edit form to create a new reord in a Boast Ownership Table,

This table has just the 2 columns Member ID and Boat ID.

Some years ago I used Visual Basic to create accounting software but now find I am struggling with Access.

 

[bob fitz]

Perhaps you could use a subform for the boat detail and relate it to the main form using the Member ID

 

[Chris Kay]

Thanks Bob. I shall have a think about this and then get back
Chris

 

[Chris Kay]

I have managed a work around that has solved my problem. Longer term I have got to get back to using VBA.
Once again thanks
Chris