using FM12 pro Advance
i have three tables one is person's details and 2nd table is for billing and 3rd is for to Monitor payments
I have Billing layout and one Portal is setted up and fields are inside the portal raw which gets clear when i need to clear and keeps the person details
What I want ?
i want counting for the each person that he/she has borrowed the money that many times which can show me in the billing layout
First, you need to correct issues in the design of your relationships.
The relationship between Final and Billing should only match by ID fields. The full name fields in Final and Monitor should be removed.
There should be a different ID field defined in Billing that uniquely identifies each Billing record and that should be used to match records in Billing and Monitor.
I would not delete records from Billing to show that the bill is paid or canceled. I'd change a status field to mark that bill as paid or canceled. Then I can count records in Billing for a specific record in FInal to get the number of times a person has attempted to borrow funds.
Thanks for the help i will do what u told thanks for the help as im new lerner in this
One correction: Keep the full name field in Final and remove it from Billing.
ok done that
how so do i change a status field to mark that bill as paid ?
Edit the field to change the data in it from "unpaid" to "paid". You can use a value list to keep the data entry consistent.
how do i get one customer with many billing records ?? and same Billing ID for all billing records
plz help me
You use this relationship between customer (final?) and Billing records:
Customer::__pkCustomerID = Billing::_fkCustomerID
For an explanation of the notation that I am using, see the first post of: Common Forum Relationship and Field Notations Explained