jgoodman00
Programmer
- Jan 23, 2001
- 1,510
Am having a wood & trees moment here!
I have a table which needs to store a information about lichen species, & what their host species is.
I currently have a table which has a list of species for everything. I would prefer to keep a single species table. The user will select a lichen species, then a host species.
I am then faced with the problem of needing to relate a single table to two fields within another table.
At the moment I have:
ID
LichenID
HostID
Any ideas?
James Goodman MCSE, MCDBA
I have a table which needs to store a information about lichen species, & what their host species is.
I currently have a table which has a list of species for everything. I would prefer to keep a single species table. The user will select a lichen species, then a host species.
I am then faced with the problem of needing to relate a single table to two fields within another table.
At the moment I have:
ID
LichenID
HostID
Any ideas?
James Goodman MCSE, MCDBA