Jump to content

nickym999

Newbies
  • Content count

    2
  • Joined

  • Last visited

Community Reputation

0 Neutral

About nickym999

  • Rank
    newbie
  1. 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
  2. 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
×

Important Information

By using this site, you agree to our Terms of Use.