Topic: Need help with One To Many relationship database.
Hello. I am making a program for my own use that has multiple parties, and each party will have multiple bills related to him. each bill will have multiple records, having quantity and weight details. My question is, how do I add and save a bill?
I can use forms to add records, and add parties., but this involves simultaneously creating a new BILL and simultaneously saving multiple records in that particular bill. When do I save the voucher, and when do I save the individual transactions in the bill?
Do I add a small form to save an empty voucher to the BILLS table, then create a new form to add RECORDS to the records table, and link to to the VOUCHERS table?