K
Kevin Kobelsky
If we have 2 events A and B that are sequential (e.g. Ship Goods and
subsequently Receive Payment) and have a M:1 relationship (i.e. many
shipments can be consolidated into one payment, but no partial payments on
shipments), how do you create a form/sub-form to record the Receive Payment
and update the Ship Goods with reference to Receive Payment table, using the
wizard? We need to be able to update all the Ship Goods rows that the
customer is Paying for.
Using the wizard, I and several colleagues were unable to achieve this. This
is puzzling because my more proficient colleagues said this is simple with
vba code. The only workaround we found was to work was to create a new
Payment/Ship table that cross referenced the Payment table key to the related
Shipment #'s. This table would be updated via a subform when the payment came
in.
I can't use anything beyond the wizards because this would be beyond the
skills of my students (this is a survey course for accounting students, so
vba scripts are out of the question). So, is it necessary to create this new
Payment/Ship table, or is there a way to directly update the Ship table via a
subform (or some other method?) at the time of Payment?
Thanks for your help,
subsequently Receive Payment) and have a M:1 relationship (i.e. many
shipments can be consolidated into one payment, but no partial payments on
shipments), how do you create a form/sub-form to record the Receive Payment
and update the Ship Goods with reference to Receive Payment table, using the
wizard? We need to be able to update all the Ship Goods rows that the
customer is Paying for.
Using the wizard, I and several colleagues were unable to achieve this. This
is puzzling because my more proficient colleagues said this is simple with
vba code. The only workaround we found was to work was to create a new
Payment/Ship table that cross referenced the Payment table key to the related
Shipment #'s. This table would be updated via a subform when the payment came
in.
I can't use anything beyond the wizards because this would be beyond the
skills of my students (this is a survey course for accounting students, so
vba scripts are out of the question). So, is it necessary to create this new
Payment/Ship table, or is there a way to directly update the Ship table via a
subform (or some other method?) at the time of Payment?
Thanks for your help,