I have a database of cards. The database looks something like this:

table cards:
cnum int(11) Pri Key auto_increment
ctitle Varchar(50)
type int(11)
artist int(11)
etc...

type and artist both link to other tables for normalization as:

table type
tnum int(11) Pri Key auto_increment
type varchar(50)

artist looks basically the same.

Now I have the data that I want to load in in a txt file that I loaded into a temp table that looks like:
cnum int(11) Pri Key auto_increment
ctitle Varchar(50)
type Varchar(50)
artist Varchar(50)
etc...

now for the question. How do I get the data from card.temp to card.list AND card.type AND card.artist?

All tables are currently blank so I want it to take the type and add it to card.type and put that number in card.list.type if the name already exists I want it to take the number from the one that already exists and place it in the list. I know this can be done, I just have not been able to find the correct command yet.

Thanks in advance,

Jason