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)

[alansidman]

Use a subform for the reservations. Look at this video for an idea on how to do it.

http://www.datapigtechnologies.com/f...subforms1.html