I have two tables. 'tabDoc' is a list of documents. 'tabLinkParents' has three fields: a key field, and two fields that lookup the foreign key for documents in 'tabDoc'. The purpose is to keep track of parent-child relationships between the documents.
I have a form based on tabDoc with a subform based on tabLinkParents. The subform is for inputting or displaying the parent documents. 'Link Child Field' is set to the key for the child document (a coincedence!) in tabLinkParents, and 'Link Master Field' is set to the document key in tabDoc. That way, for each document in the database, the subform displays the parent documents.
The subform displays data correctly when I add data to the tables directly, but when I try to add data using the subform, I get the following error message:
The LinkMaster fields property setting has produced this error: 'the object doesn't contain the Automation object 'tabDoc.''
BTW, I can sucessfully add records to tabLinkParents using the query for the subform, so I know its not a problem with a non-updateable record source
Is there a problem having simultaneous relations between two of the fields in tabLinkParents and the (single) primary key of tabDoc?
Suggestions for fixing the subform?