Hi, I would appreciate any help with this please . It really has me stumped and I have spent many hours trying to find info to put me on the right tracks.

I have an db (Access) which has a 'Regions' table related to a 'Towns' table related to a 'New Properties' table.

I am using Dreamweaver to build an insert record page. When I go to insert a new property using my form I get the error:

ADODB.Command error '800a0d5d'

Application uses a value of the wrong type for the current operation.

Now I am assuming this is because I cannot add the new property record without the relationship between the regions and town tables having been formed. However I 'thought' I was doing this by inserting the town and region id values from my form into the FK townID and FK RegionID fields. Have I got my db relationships set up incorrectly?

Im sorry Im sure this is something very obvious, but at this moment in time it is not to me and I would really appreciate any help.

Thank You

Gary MG