In your sci-fi example, there would be a many-to-many relationship between
Planets and Species, i.e.:
- one planet has many speicies, but also:
- one species can appear on many planets.
You need 3 tables to handle this relation:
- tblPlanet, with PlanetID primary key;
- tblSpecies, with SpeciesID primary key;
- tblPlanetSpecies: one record for each combination, with foreign keys
PlanetID and SpeciesID.
The subform would be bound to tblPlanetSpecies, with a combo box to select
the species.
For another example and more detail, see:
http://allenbrowne.com/casu-06.html
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Alienz" <ks*****@yahoo.com> wrote in message
news:58*************************@posting.google.co m...
Lets say I have a form called Planet_Systems and a form called
Species. I then want to link the primary key "Planet" to bring up
it's various species in the corresponding subform. So, I created a
subform species within the forum Planet_Systems. They're linked
properly and related etc.. I typed into the Planet combobox: "Earth".
I would now like for all of the different Species found on Earth to be
listed in the subform automatically once I click on a button in the
main form or something. I guess it's sort of a lookup or requery
function but I'm not too sure. Any experienced Acces users know what
I'm trying to do here?