|
bonsaiTALK Master Craftsman
Join Date: Apr-2004
Location: Nr Halifax
Country: England
Posts: 857
|
Quote:
|
Originally Posted by Forest Reef
I will set up my system so I can sort down to the cultivar level where it counts to me, one way or another. If I have to make separte entries for "Acer palmatum", "Acer palmatum Kiyohime", etc., I guess I will (that is, put cultivar info in at the species level). That probably means a lot of "Acer" info is going to get stored multiple times. Not the best way....
Enough for now....
|
The best way to do this would be to use one table to store Genus and Species information (Leaving the more detailed information required optional. Then create another table and sub-form to store Cultivar/Variety information, where the more detailed information is required, then create a relationship between the two, allowing the data to be searched, minimising repeated data which will clog up a database, as Genus/Species info would only have to be entered once (+ Cultivar/Variety info will only have to be entered when required)
I hope this is clear, its early and i have to go to work, if its not i will try and make more sense of it when i get back tonight.
Cheers
Rowan
__________________
In literary and art criticism there are two criteria, the political and the artistic....
Words and actions should help to unite, and not divide, the people of our various nationalities
I often talk to myself because i am the only one who truly understands me.
|