Hi all,

I am new to FMpro v6 having mostly worked with PHP/MySQL. I have a fairly basic problem which I could code in PHP but am stuck with filemaker!!

The system is for handling customer orders of books and then converting these to supplier orders. The files I have are as follows:-

Customers:- cust_id, name, address, etc

Books:- book_id, name, title, author, supplier_id (which relates back to cust_id in books, as some customers also happen to be publishers)

Customer orders:- order_id, cust_id, dates, etc

bookorderjoin:- orderjoin_id, order_id, book_id, quantity, etc (this is for line items of customer orders)

supplier orders:- supplier_order_id, supplier/cust_id, orderjoin_id etc

All of this works OK apart from creating supplier orders. Basically what I need to do is create numerous orders to suppliers based upon a summary of the customer orders. ie create one supplier order addressed to the supplier for each customer listing their book requirements. I have created a report sorting the bookorderjoin file by supplier by customer, thereby grouping the data that needs to be filled in on the supplier order, but I am not sure how to carry on.....

If anyone can offer any advice, it would be greatly appreciated.

nickym999

You are probably already done with this, by now, but here is my 2 cents -- please see attached.

By adding two lookups to your Link table, the Supplier Order is a little easier.

tryme.zip