converting customer orders to supplier orders

[nickym999]

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

[zincb]

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