Hi I ma new in php and also in fabrik. I am trying to develop an application but at one point i cant move forward, please help me. Here is my situation:
I have four tables in my database:
1. Requisition (R_ID, Ref_No, Date)
2.Requisition Detail (RD_ID, R_ID, Head_Name, R_Amount)
3. Payment (P_ID,R_ID)
4. Payment Detail (PD_ID, P_ID, Head_Name, Pay_Amount, Date)
Here requisition is parent table and requisition details is child table, same for payment and payment detail table. Here everything is working fine, but i want check in payment repeated group element where Pay_Amount cannot be greater than R_Amount. This condition will be apply for each Head_Name. I have also attached picture of my situation.
I have four tables in my database:
1. Requisition (R_ID, Ref_No, Date)
2.Requisition Detail (RD_ID, R_ID, Head_Name, R_Amount)
3. Payment (P_ID,R_ID)
4. Payment Detail (PD_ID, P_ID, Head_Name, Pay_Amount, Date)
Here requisition is parent table and requisition details is child table, same for payment and payment detail table. Here everything is working fine, but i want check in payment repeated group element where Pay_Amount cannot be greater than R_Amount. This condition will be apply for each Head_Name. I have also attached picture of my situation.