G
Guest
How do I set up an autoupdate query (using a form) that will automatically
popuplate a table with data from another table? Example of the table to
update..
PLTable.Activity Number (Text)
PLTable.Entered by (Date}
PLTable.ViolationCite (Text) update from ViolationTable.ViolationCite
PLTable.ViolationAmount (Currency) update from ViolationTable.ViolationAmount
PLTable.MaximumAmount(Currency) update from ViiolationTable.MaximumAmount
My relationship is one (ViolationTable.ViolationCite) to many
(PLTable.ViolationCite)
I get no autofill of the fields in the PLTable when I enter the
ViolationCite either in the query or the form. The source of the form is the
query.
popuplate a table with data from another table? Example of the table to
update..
PLTable.Activity Number (Text)
PLTable.Entered by (Date}
PLTable.ViolationCite (Text) update from ViolationTable.ViolationCite
PLTable.ViolationAmount (Currency) update from ViolationTable.ViolationAmount
PLTable.MaximumAmount(Currency) update from ViiolationTable.MaximumAmount
My relationship is one (ViolationTable.ViolationCite) to many
(PLTable.ViolationCite)
I get no autofill of the fields in the PLTable when I enter the
ViolationCite either in the query or the form. The source of the form is the
query.