Thank you so much.

I altered the code, then checked to see what was inserted to the database.

The foriegn key field is not updating (this is linked to an autonumber field)

So i will use what you found and edit the relationship.

I also found code that updates the foriegn key in the SQL but i can't find it again now. Which is quite annoying.

Your help is much apprieciated.

Regards
Brian