Hello Roger!
Thanks for getting back to me so quickly. Here is what I have got so
far:
tblTours
tourId
description
longdescription
image1
image2
baseprice
tblCategories
categoryId
categoryname
tblDestinations
destinationId
destinationname
tblOptions
optionsId
optGroup
optName
optPriceDiff
optWeightDiff
I am aware that I probably need to create a junction table or something
like that but I can't seem to get things working. I need each tour to be
available to several different categories and at the same time available
for different destinations.
Like the tour Scandinavian Capitals. This tours goes to Norway, Sweden,
Denmark and Finland. The tour includes husky safari, fishing, cruising,
sightseeing and fjord tour. So somehow I need to make this work by
setting my database up in a many to many relationship way I guess but I
have tried so many times I guess I am as blind as batman right now...
:-) Hope you can help me! Thanks!
*** Sent via Developersdex
http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!