Sales database

[Hello1]

I didnt define a business. Would say its a retail (small mobile shop or something), where customer order comes face to face. It would be cool to make online support too, so they can buy online and we deliver (would mean also to define delivery with tables and so) but I dont have time to go so deep :/
Anyhow, what Im interested in is are these relationships Ok and can I do next with these tables and relationships...
1) When I make a quote it will have a status of new and then further it will be possible to send the quote to a customer so it will have a status of sent. If the quote is accepted by the customer I want it to be invoiced (after I click the invoiced button in the form) and automatically to convert into an invoice. Do I need VBA or Macros for this or is there a workaround without them bcoz I dont really know to use them (is there a tutorial for something like this?).


2) When an invoice gets the status paid or completed (dono yet how I will name it), can I make it possible that the products and the quantity from the invoice, including the date, are written in the stockMovements table automatically with the status "stock out". Guess for this there is no way to make it without coding, if so, is there a tutorial for this?
3) And last is the PurchaseOrder, like the invoice just to get the status "stock in", but guess I would figure out this one if I know the answer for the previous question.

[CJ_London]

what Im interested in is are these relationships Ok

As I said, they look OK, but it depends on the business/rules/processes etc as to whether they are really OK. I can't help if you are not prepared to put that work in. If you don't then your development style will be 'try it and see' which is the most inefficient way of developing.

To answer your questions,

1. yes you will need to use VBA/queries. You can use macros rather than VBA but they are much more limited in what you can do
2. I'll answer with another one - what happens if an invoice is part paid? Personally since you are talking more of a receipt rather than and invoice, I would put the invoice line in the transactions table
3. same as 2

Think I already suggested answers to 2 and 3 in post #2

[Hello1]

For some reason after making a report, the logo shows in report, layout and design view but not when I save the report as PDF or go to print preview.
Another thing, I tried to make sum calculations in the footer and found out that doing that isnt possible. I read somewhere that its possible with VBA but no clear explanation. However, I found a workaround with making the calculations above the products.

[CJ_London]

You are now on a completely different subject. I have marked this thread as solved. Please repost your last post into a new thread with an appropriate title.