converting customer orders to supplier orders

[nickym999]

Hi all,

sorry to cross-post but I think I chose the wrong area!

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

[Ugo DI LUCA]

There are many parameters to consider with these procedures, and therefore many solutions that could be provided according to how automatic this procedure may be.

One book could be purchased in several places (wholesalers or the publisher itself), rendering quite impossible any automation. If it's not, you could have a look to this thread , where Steve Brown (Spd) gives some insight on how he is currently doing it.

[Anatoli]

Go for PHP for FileMaker.

Or you can try Lasso from BlueWorld