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.