[newbe]

Hi I have a small database, with few tables and I want to make this process: “Offer -> Order -> Bill” To make the Offer I want to use these two table: Customer; fields: NAME, ADDRESS etc. (these fields should changes if I change them in the...

Hi
I have a small database, with few tables and I want to make this process: “Offer -> Order -> Bill”
To make the Offer I want to use these two table:
Customer; fields: NAME, ADDRESS etc. (these fields should changes if I change them in the customer table, at least in the Offer) This should be in the header of the form.
Pricelist; fields: NAME, DESCRIPTION, PRICE. (I want to be able to change these fields in the Offer, without changing the primary table and also if I change these fields in the primary table, it should not change in the form). In the Offer, I also want to adds these fields: QUANTITY, DISCOUNT, SUM (for each line) This should be displayed in multiline sub form.
I also want to add some TEXT, and DISCOUNT for the whole offer + sum and some calculation.
I’m aware of that this is not my idea, somebody must have done this a million time I just cannot find anything on the www or in the Access help, and I don’t have any books.
What are the main rules for this?
Is this process described in some book, what book?
Does somebody have a sample database to let me have?
Best regards, Sigurdur Thor