inserting references

I have a table, which references
values in other 3 tables.

I would like to insert values in
bananas, oranges and kivi tables
and insert their bananas_id,oranges_id,kivi_id,
country
in fruits table.

What are better methods for doing
this(exept LAST_INSERT_ID())?
Would be nice to use the most compact form.



sample tables scheme

-----------   ----------   ----------   ----------

fruits        bananas      oranges      kivi

-----------   ----------   ----------   ----------

fruits_id     bananas_id   oranges_id   kivi_id

bananas_id    date_bn      date_or      date_kv

oranges_id    ----------   ----------   ----------

kivi_id
country

-----------

__________________________________________________
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com