Hi all,

This is my first post so please be kind! I am writing an order management system at the moment. The problem I am having is trying to locate which orders are ready to be sent. Each master order contains one or more line items. I can find whether a line item is ready to be sent (in stock) but want to ship an order only when all items are ready. The search I need therefore is for each order, to check whether all items are ready. I suspect that this will be some form of loop script but can't get my head around it. Has anyone done anything similar or can offer advice?

Many thanks - this is a great forum!

Matt

First define a calculation field in order lines table. That returns 1 if the item is in stock, 0 if the item is out of stock.

Define an other calculation field in master order table. Compare line items (with count function) and line items in stock (with sum function) by the relation. If they are equal order is ready to ship, else "items_in_stok/total_items * 100" percent is ready (aspect of items)

Now you can search and find ready to order records in master table.

Thank you so much! Would never have thought of that. Brilliant!

Matt