Multiple FK constraint question

Hello all!!
I've created a table called individual. It has a field called firstname. I have 2 look-up tables expand_name and gender_code where the primary keys are abbreviation and value respectively. I have foreign keys in the individual table pointing to these 2 lookup tables. My question is, can I do this? Is it allowable for have 2 FK constraints (or more) on a single field in a table? I checked the user_constraints table and both are listed as being there. But, when I look in Oracle7 Navigator, it show only the gender FK, the expand FK isn't listed. I am having trouble loading this table from SQL Loader with it giving an error of:

ORA-02291: integrity constraint (kgrigg.individual_expand_n_fk) violated - parent key not found

I have already loaded the expand_name and gender_code tables. I believe I have it set up where there may or may not be a value in the look-up tables for a value in the firstname column of the individual table. So, any ideas on what is giving me this error? Is it my setup (multiple FK on one field)?

I am moderately experienced with SQL and relational DB's, but, I am a complete newbie with Oracle. I would greatly appreciate any suggestions or pointers to where to look for more information. I am currently looking through 'Oracle: The complete reference' and haven't come up with anyting.

TIA!! Kelly
kgrigg_at_acxiom.com
cayenne_at_cei.net

ps. Please CC by mail in addition to posting...our newsfeed here isn't very reliable!!

"If you've had half as much fun as me...

    ....Then I've had twice as much fun as you!!"

kgrigg_at_acxiom.com
cayenne_at_cei.net

Visit my Website at: http://www.cei.net/~cayenne/index.html Received on Fri Aug 15 1997 - 00:00:00 CDT