.

i knew i wasnt that hopeless!

ill try and explain...


4 tables

customer, order, order line, stock

one customer can have many orders
one order can have many order lines
many order lines can have one stock item

Basically, yes.

The structure of your tables and any relationships between them (altho relationships aren't necessary).

ive never heard that term before... do u mean relationships?

Oh dear.

schema?

I was about to ask the same

CorsaLad - have you got an example of your DB schema?

joff - yeh i know that but ive left it a bit late! :lol:

jodi - ive tried to create an invoice based on a query, using a wizard but there doesnt seem any way to group the data on the invoice. what i mean is i could have orderID and the date in one box, customer details below it etc...

You would be better seeking help from a dedicated Access forum, or even help from your tutors - that's what they're there for.

Yeah as you will need to print out an invoice to send out, therefore it will have to look professinal

ok cool!!

i am creating a system for a hardware/software resale company. my system is nearly complete, but i need to create an invoice. do u think a report is the best way to do this?

I can help you, I also had to use it for my a-level course work

please reply if u have a good knowledge of microsoft access, 2000 in particular. this help is for my final a level coursework and so i would appreciate any help!

thanks

james