Booking system form

[pelicanbuyer]

I am trying to create a party booking system.

I have a table for customer details and a table for requirements on a party that they book.

I can obviously create one form to input data in to both tables but I am not sure how to show which party belongs to which customer.

Can anyone shed some light?

I realise I can have a Customer ID in both tables and link them but I am not sure how to write to both tables from the form or to have a button that does that for me when I click to book a party, assuming that is the best way?

(Not all customers book parties)

 

[catalin.petrut]

You will need to create another table to join the two tables becouse one customer can go to many parties and at a party can come more customers. It will be a junction table. So you will have:
TBL_CUSTOMER
customer_id
Other customer infos
TBL_PARTY
party_id
Other party infos
TBL_ATTENDENCE
id
customer_id
party_id

Then create a form and a subform using the wizard and group the form by customer or by party (depends on your demands)