F
FJB
One of the databases I work in each day has two tables which are
related to one another. The SWL Table is made from data in the SAR
table. A query is run on the primary table (SAR) to select the records
which need to be appended to the SWL table. There is a field in each
table which I must update (LOB). Rather than doing it one table and
then the other, I built a form with a subform. The SAR fields are on
the form with the SWL field on the subform. I am unable to update the
SAR fields but have no problem updating the SWL fields. When I update
the SWL field it populates the SAR field but the information is not
saved. Any thoughts will be greatly appreciated.
Frank
related to one another. The SWL Table is made from data in the SAR
table. A query is run on the primary table (SAR) to select the records
which need to be appended to the SWL table. There is a field in each
table which I must update (LOB). Rather than doing it one table and
then the other, I built a form with a subform. The SAR fields are on
the form with the SWL field on the subform. I am unable to update the
SAR fields but have no problem updating the SWL fields. When I update
the SWL field it populates the SAR field but the information is not
saved. Any thoughts will be greatly appreciated.
Frank