R
rocketD
Hi All,
I'm working on a data table in which I'm trying to create lookup
wizards for two fields: Genus, and Species. I've got the lookup
tables complete, each with 2 fields (an ID and the latin name). I want
to use the lookup tables for the Genus & Species fields in my parent
table, so that when I create the form for future data entry, the fields
will have a drop-down box. However, there is already a ton of data in
those fields in the parent table, and every time I try to add the
lookup tables, it says it will delete all of the values in those two
fields. It would be a horrendous amount of work to re-add it, there's
more than 7,500 records. I've tried appending the data into a
structure only copy which has the lookup tables related already, but
that doesn't work either. Can anyone provide some advice, please??
Thanks,
Dara
I'm working on a data table in which I'm trying to create lookup
wizards for two fields: Genus, and Species. I've got the lookup
tables complete, each with 2 fields (an ID and the latin name). I want
to use the lookup tables for the Genus & Species fields in my parent
table, so that when I create the form for future data entry, the fields
will have a drop-down box. However, there is already a ton of data in
those fields in the parent table, and every time I try to add the
lookup tables, it says it will delete all of the values in those two
fields. It would be a horrendous amount of work to re-add it, there's
more than 7,500 records. I've tried appending the data into a
structure only copy which has the lookup tables related already, but
that doesn't work either. Can anyone provide some advice, please??
Thanks,
Dara