How to: Manipulate Multivalued Fields With DAO
|Access Developer Reference|
Multivalued fields are represented as Recordset objects in DAO. The recordset for a field is a child of the recordset for the table that contains the multivalued field. To instantiate the child recordset, use the Value property of the multivalued field as follows:
The following example illustrates instantiating the child recordset of the AssignedTo field of the Tasks table.
The child recordset has the same functionality as any DAO Recordset object.
The following example illustrates how to iterate through a parent recordset and its child recordset. The example prints the tasks in the Tasks table along with the people assigned to the tasks to the Immediate window.