>I am using SDI forms, so the user can only open 1 at a time.
>
>How can I relate the fields, if I open several recordsets?
>
>Thanks for your help

Then that makes it easier. There are two things that might work:
1) Open the additional tables in separate recordsets and use the Find method of the recordset to find related data. Unfortunately there is no way to relate separate recordsets on the client-side. This is the simplest.

2) Use a Select statement as the source to the recordset that joins the appropriate tables for each form. On this type of recordsets you can only make changes to one table, so make sure you include all fields from the table that needs processing.

HTH