Information générale
Catégorie:
Bases de données DAO/RDO/ODBC/ADO
>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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement