Need a query for my Invoice requisition app

[Ayan_Basak]

In my Invoice requisition app there are 3 tables i.e. Invoice requisition, Submissions, FMS. I need a query for my Invoice requisition table a field named 'Invoice value' where I have to put a query. The conditions are "Take user input for Invoice Value when Delivery Type is Partial. The Invoice Value should not be greater than the Basic final Revenue (Submissions) of the Contract ID(Submissions). Also, it should consider any previous Invoice Requisition(FMS) generated for the same Contract ID(FMS) "

THANKS IN ADVANCE. 

[WillowMobileSys]

Sorry, this is not clear.  If you still need help, it would best if you could include images of the columns in the 3 tables within AppSheet.  The big question is what relationships are there between these 3 tables.  The table columns will help figure that out.