P
phuser
I have a main form "Payments" that contains a users input for Date & cheque
number,
now I tried to make the subform "payment by supplier" a child by "OrderID"
as both tables contain the field, but when I did that it made all the unpaid
invoices dissapear because of course there is nothing in the payments table
to link them. The subform contains all the data of unpaid invoices Invoice
#, customer, amount, owing, etc, etc. Right now for all the correct data to
go where it's supposed to the user has to enter in the amount paid (which I
want to keep) but also has to enter for each invoice paid the cheque number
& the date, I ended up just removing the Date & cheque number from the main
form as it was only teasing everyone, what should I put in the "AmountPaid"
AfterUpdate event to trigger the date & cheque# fields in the subform.
number,
now I tried to make the subform "payment by supplier" a child by "OrderID"
as both tables contain the field, but when I did that it made all the unpaid
invoices dissapear because of course there is nothing in the payments table
to link them. The subform contains all the data of unpaid invoices Invoice
#, customer, amount, owing, etc, etc. Right now for all the correct data to
go where it's supposed to the user has to enter in the amount paid (which I
want to keep) but also has to enter for each invoice paid the cheque number
& the date, I ended up just removing the Date & cheque number from the main
form as it was only teasing everyone, what should I put in the "AmountPaid"
AfterUpdate event to trigger the date & cheque# fields in the subform.