Recent content by ZoeMaKayla

@Mark Thanks, first the system can allow for payment without order raise and the payment can be applied to the order whenever raise. Also, the payment on an invoice can either be once or installmental and can still keep tab on the order as against the payment thirdly, another customer with...

@Mark, I want to allow for third party payment aswell

@mark thanks, I would try this out and keep you posted

@ridder, YES

Hi all, My answer to mark's questions I have the following tables alongside other tables tblSalesInvoice and tblPayment with relational field as the customers Name and Invoice Number, I want to do the following ) one payment apply to more than one sale? 2) Accept a partial payment (such that...

@arnelgp Thank you for a wonderful contribution but its not fitting into the database. Can you please send your email to me so as to push to your email the database i am redesigning @Uncle Gizmo, I have answered Mark's question already. the rule 1 & 2 is exactly what i wanted to answer in the...

@Mark, I haven't had from you yet. Please kindly reply and waiting for your help

@Mark Thanks. Your Question for business rules 1 & 2 is exactly what I need. Can you please help.

@Mark Thanks, I have tried the link and also, a subdatasheet to link the query and the tblPayments but i have to manually typed the total into the tblPayment field for the Total Amount. I dont want to repeat this I want it automated into the field directly from either the query or the...

@Plog, thanks for your response. But I still need to store the data in a field in tblPayment table and Payment made can be used and another field in the table calculate the balance which is store in the field to be call back whenever the information is refer to

Hello All, Please I have a table tblSalesInvoice and a table tblPayment to take the payment from the Sales Invoice. But I couldnt collect the total sum of the order on the Sales Invoice. I have tried creating a query that does the sum but also couldnt move the sum of the order to the payment...

Please I have a MS Access Database with an invoice that and the query that calculate the total order on invoice. Also, I have another table for Payment Details but I need to pick the total for order on Invoice to a field for Total on Payment Details. Can any one please help with this