I\'m buildling a database of vineyard properties in Sonoma County and I am unsure as to how to build some \"sets\" of values. Each property can be in one or more appellations, grow one or more grape varieties and have one of several classifications.
I was going to build each of these as a table, then I can add new appellations, grape varieties or classifications as they appear without altering the database.
But in all the books I bought, there are no examples of creating the one to many relation I want to make between the \"properties\" table and the \"appellation\" and \"variety\" tables. And I am wondering what the queries are going too look like.
Help?
Peter Young
