I have a database that has student table (I am not a student doing an assessment!) with a one to many relationship to coursebooking and then a course table that has a one to many relationship with the coursebooking table so coursebooking seems to be acting as the link table between the many to many relationship. (I didnt design it).
I am creating forms to make the booking process faster and to perform the correct sums to produce an invoice and update a financial transactions table along the line.
I have an entry form that creates the student, and then other forms synchronise to the master form and gather the data. I am now at the point of wanting to get product details so ex course A, taxi to school and enrolment fee and add these to the booking table.
Historically the process was messy and couldnt calculate course A cost (per week) times by number of weeks.
I want to be able to select the products from a combo to build up an invoice and then once acknowledged as details correct commit to the tables coursebooking and transaction table.
I am not sure how best to achieve this ie is it best to have a bound form to the booking table and add new records to it line by line or to use an unbound form and some kind of product picker and to see the products built up perhaps using vba and storing products in an array until ready to post.
Some advice would be most welcome.
regards
Peter
I am creating forms to make the booking process faster and to perform the correct sums to produce an invoice and update a financial transactions table along the line.
I have an entry form that creates the student, and then other forms synchronise to the master form and gather the data. I am now at the point of wanting to get product details so ex course A, taxi to school and enrolment fee and add these to the booking table.
Historically the process was messy and couldnt calculate course A cost (per week) times by number of weeks.
I want to be able to select the products from a combo to build up an invoice and then once acknowledged as details correct commit to the tables coursebooking and transaction table.
I am not sure how best to achieve this ie is it best to have a bound form to the booking table and add new records to it line by line or to use an unbound form and some kind of product picker and to see the products built up perhaps using vba and storing products in an array until ready to post.
Some advice would be most welcome.
regards
Peter
