B
brback via AccessMonster.com
Not quite sure where i should post this, but since i didn't find any "tables
discussion group" i ended up at queries. As i am already confused enough i
will use the original names for the stuff in my base and hope you can keep
track of it instead. I got 3 tables: Pet, Species and Breed. Species has a
one to many relation to both Pet and Breed
PET
Pet_ID (Primary key)
Pet Name
Species_ID
SPECIES
Species_ID (Primary key)
Species name
BREED
Breed_ID (Primary key)
Breed name
Species_ID
Making a querie with these 3 tables combined does not turn out well. The idea
behind this querie is to choose pet name first, then set Species, and at last
choose the Breed under the chosen Species.
Ive experimented a bit with the relations and changing PET/Species_ID to
Breed_ID, making a one to many relation from Pet to Breed, and yet another
one to many relation from Breed to Species. This turned out fine when making
a querie. Only trouble know is that i cant determine Breed out from Species,
since i have to choose Breed first, and when chosen Species is set
automatically.
I've been struggling alot to make a solution to the first option where im
supposed to pick a Breed after i've set Species. If anyone of you can help me
out with this which hopefully has an easy solution I'll be more then pleased.
If you have any question or ive been vague at some point feel free to say so
Thanks alot in advance!
discussion group" i ended up at queries. As i am already confused enough i
will use the original names for the stuff in my base and hope you can keep
track of it instead. I got 3 tables: Pet, Species and Breed. Species has a
one to many relation to both Pet and Breed
PET
Pet_ID (Primary key)
Pet Name
Species_ID
SPECIES
Species_ID (Primary key)
Species name
BREED
Breed_ID (Primary key)
Breed name
Species_ID
Making a querie with these 3 tables combined does not turn out well. The idea
behind this querie is to choose pet name first, then set Species, and at last
choose the Breed under the chosen Species.
Ive experimented a bit with the relations and changing PET/Species_ID to
Breed_ID, making a one to many relation from Pet to Breed, and yet another
one to many relation from Breed to Species. This turned out fine when making
a querie. Only trouble know is that i cant determine Breed out from Species,
since i have to choose Breed first, and when chosen Species is set
automatically.
I've been struggling alot to make a solution to the first option where im
supposed to pick a Breed after i've set Species. If anyone of you can help me
out with this which hopefully has an easy solution I'll be more then pleased.
If you have any question or ive been vague at some point feel free to say so
Thanks alot in advance!