Hi All

I'm new to filemaker and having problem creating a payment system.

Basically I’ve a table for customer order which have it own unique ID.

Customer will leave deposit and pay balance on pick up or lay-by the order.

I’ve another table recording all customer payment with unique ID.

What I’m trying to do is create a payment system such that payment is link to Order.

The problem arise when customer have more than one order but one payment. How do I go about sort out this problem? Please help!!!

you simply apply the one payment to two orders - it requires someone to know how much of one is paid - there should be no restriction on the number of invoices a payment will apply to - obviously you have to balance the payments with the deposit at the end of the day.