S
Simon Harris
Hi All,
I am currently designing an Access DB for storing details of who is staying
in what pitch on a number of Holidays parks. So far, I have the following
table structure:
tblCustomers----tblAllocations----tblPitches----tblParks
I want to have a form that allows adding/update of customers, including what
site and pitch they are on, which I want to store in the allocations table.
Can anyone advise how best to achieve this? Should I design a query that
does the join, then make this the source of the form? Or perhaps manually
run SQL commands to to the various updates following the save/update button
being clicked?
Thanks,
Simon.
I am currently designing an Access DB for storing details of who is staying
in what pitch on a number of Holidays parks. So far, I have the following
table structure:
tblCustomers----tblAllocations----tblPitches----tblParks
I want to have a form that allows adding/update of customers, including what
site and pitch they are on, which I want to store in the allocations table.
Can anyone advise how best to achieve this? Should I design a query that
does the join, then make this the source of the form? Or perhaps manually
run SQL commands to to the various updates following the save/update button
being clicked?
Thanks,
Simon.