Help with invoice number: sample attahced

hullstorage

Registered User.
Local time
Today, 21:35
Joined
Jul 18, 2007
Messages
213
can somebody tell me where i am going wrong
i want to allocate an invoice number for multiple records in this database

database sample attached which may give you some idea
 

Attachments

Based on what your asking for, I would say Invoice ID should appear on the deliveries table, and delivery id should not appear on the invoices table. The only thing I would question here is it seems like the possibility of human error is high. You should make sure to use some kind of control, like a form control combo box. It may be a good idea to show more than one field in this control as well.

Other things to note: you should avoid using spaces in the names of access objects and field names.

A bigger problem I see is that you have the field customer id in the customer table and invoices table. Make sure this isnt an error! If customerid field is needed with invoice records, use queries to bring this info together.
 
Based on what your asking for, I would say Invoice ID should appear on the deliveries table, and delivery id should not appear on the invoices table. The only thing I would question here is it seems like the possibility of human error is high. You should make sure to use some kind of control, like a form control combo box. It may be a good idea to show more than one field in this control as well.

Other things to note: you should avoid using spaces in the names of access objects and field names.

A bigger problem I see is that you have the field customer id in the customer table and invoices table. Make sure this isnt an error! If customerid field is needed with invoice records, use queries to bring this info together.

but wont i get a new invoice no everytime i enter a delivery, i need 1 invoice number for say 15 deliveries which we invoice at the end of the month.

i have now removed customer id in the invoices table.

other than that do you think the database looks about right.

thanks
simon
 
but wont i get a new invoice no everytime i enter a delivery, i need 1 invoice number for say 15 deliveries which we invoice at the end of the month.
No. Invoice id in the delivery table would act as a foreign key. You will be allowed to enter the invoice id that you want to be associated with each record in the delivery table. You could enter it by typing the numbers, or set up a combo box.

other than that do you think the database looks about right.
From what I have seen, yes. Dont forget to fix the spaces in object names though.
 
sorry to be a pest but your the only person who seems to have a clue what i am trying to do:

i think i am nearly there just a couple of things

i have changed field names and relationship etc as you said and everything seems ok

i just a bit confused at how to create the form where the invoice number comes into it

i have uploaded the database again whithe the changes applied
and a form sample at how the data will be used to give you an idea.

i think i will probably end using the dmax function for the invoice number

once i accomplish this then i will have a better understanding and create
the real database that i will be using

thanks again
 

Attachments

Last edited:

Users who are viewing this thread

Back
Top Bottom