Information générale
Catégorie:
Bases de données DAO/RDO/ODBC/ADO
Good day Eric,
I need your help again if you've got a minute.
If I am using the two adodc connections along with two tables and forms that are linked with SQL how can I add records and save them in the second table? The adodc SQL that I use (per your suggestion) to link the tables from the first form is: SELECT * FROM FirstTable AS Old
LEFT JOIN SecondTable AS New
ON New.CustNum = Old.CustNum
When the second form is loaded I use the code you suggested again:
Set firstForm.adodc1.Recordset = secondForm.adodc1.Recordset
How can I get the second table to add a new record? Since it is linked using the adodc SQL I am unable to use "Adodc1.Recordset.addnew" property to create a new record in the second table as the adodc on the second form is set to show the recordset of the first table.
Thanks for your help in advance!!
Max
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