Yes thats right..is that good practice you reckon?

If i have a business key i would add that to the main table and add that record then do a lookup before i add to the child table..is that what you mean?

thanks for your help

Fred