I have just started to learn SQL Server 2005 and am using it together with an Access .adp as front end. So - in SQL Server I have created two tables: tblProducers and tblProducts. I have also created a relationship between the two, using fields named ProducerId in both tables. In Access I have created a form for tblProducers with a subform for tblProducts. My problem is that I cannot insert new records in the subform. Whenever I create a new record in the subform, the value for ProducerId does not get copied from the main form, resulting in value NULL and therefore insert fails. What am I missing here?