Database help

[EmbPerC]

Hi all,



I am new to this site and also new to access itself.

I have started to create a basic project management database to use at work, rather than use this as a continuous database it will be used as a template for each new project (I do not have enough experience in access to design a complete database).

My first question is, I have designed a table and a form based on our client orders, I have managed to use a query to pull through the necessary info from our products list but the issue I have is we have three different set prices for our products; an early bird price, standard price and a late price. These are pre-set prices which are detailed in the products tables. When placing an order, depending on what dates have been set for the cut off of those prices I need to be able to allocate that price to the order (where as at the moment the form just pulls through all three prices). Any idea on how to do this?

My second question is, In addition to having the 3 pre-set prices, sometimes, depending on client or project, we might assign a 'bespoke' or 'custom' price for a product if say for instance they have spent a lot of money with us. I will need an additional place to be able to freely enter this figure in rather than use a pre-set price. How would I do this?

Lastly, once all of the above has been sorted out, I need to turn these orders into invoices to pull through the correct info to sum the total and include VAT @20% but I will need to edit the VAT depending on whether they are VAT registered or if the VAT changes.

I know this is probably a lot to ask for, but any help would be very much appreciated.

My experience with access is non-existent so most of the terminology would need to be basic!

Many thanks for your help and taking the time to read my query.

[June7]

Your options:

1. a separate record for each price, including the 'custom' pricing and save this record ID into the order item record

2. save the actual price into each order item record - will require code to save the pre-set price into the record and this will allow the field to be editable by user

Same goes for the VAT % ( what is VAT)?