Creating a new record programatically

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

I have a table with the following:

Booking Number
Invoice Number
Booking Detail 1 ...
Booking Detail ... n

In order to create a new booking record, the user needs to first create an
invoice record, note it down, and then come to the booking form and enter
said invoice number into the record... The invoice numbers are sequential.

I know this is a poor way to implement becuase the user must manally create
and invoice numebr and then go to the booking form and enter that invoice
number in... too many steps and error prone.

I need help on a method for creating the invoice number one I create the new
booking record. But, if the user fails to enter all required data or exits
prematurly, the form needs delete the data that was entered including the
invoice record.

any help would be greatly apprecitated.

thanks,
mark
 
I have a table with the following:

Booking Number
Invoice Number
Booking Detail 1 ...
Booking Detail ... n
Click to expand...

What are the "booking details"? It sounds like you have FIELDS named
Booking Detail 1 and so on - in other words, a "wide-flat" spreadsheet
type table, instead of a properly normalized "tall-thin" pair of
tables in a one to many relationship. Am I misinterpreting?
In order to create a new booking record, the user needs to first create an
invoice record, note it down, and then come to the booking form and enter
said invoice number into the record... The invoice numbers are sequential.
Click to expand...

Use a Form and a Subform, with the Invoice Number as the Master/Child
Link Field.
I know this is a poor way to implement becuase the user must manally create
and invoice numebr and then go to the booking form and enter that invoice
number in... too many steps and error prone.

I need help on a method for creating the invoice number one I create the new
booking record. But, if the user fails to enter all required data or exits
prematurly, the form needs delete the data that was entered including the
invoice record.
Click to expand...

Please clarify your table structures. How many tables are involved?
What is a "booking" in relation to an "invoice", and what is a
"booking detail"?
 
Back
Top