My First Access Database

[replicant00A52]

departure dates are set in advance. a trip leaving in august may have a different price than a trip leaving in sept that was otherwise identical. There is no discount rate that can be applied across all tours. each tour will have differing pricing depending on if customers are traveling single, double, or triple. so for normalization i put the following fields into my original table:

ProductTable
- ProductID (primary key, auto number)
- TourName (text)
- Days (number)
- DepartureDate (date/time)


- SglPrice (currency)
- DblPrice (currency)
- TrplPrice (currency)

the departure date and the price structure will more often than not be unique information, arbitrary values specific to the trip and nothing else.

[RayMilhon]

In that case you need to break up your product table into 2 tables.

ProductTable
ProductID (Primary key, autonumber)
TourName (text)
Days (Number)

TourTable
TourID (Primary key, autonumber)
productid (number, foreign key)
DepartureDate (Date)
Price (Currency)

Your salesTable would then be
SalesID (Primarykey,autonumber)
Productid (foreignkey, number)
tourid (foreignkey, number)
Qty (number)

That may not be complete as I can't go back and look at my previous post but it's close