AnsweredAssumed Answered

How to add new invoice when you import line items?

Question asked by ultranix on Jun 10, 2018
Latest reply on Jun 10, 2018 by ultranix

What I want to do is import a trading report into Filemaker. I would use analogy with invoicing solution, it may help better understand what I want to accomplish.


The report file is like line items table - there all orders on all trade are stored. Different trades have different ID's, but one trade can have more than 1 order for opening a position and more than 1 order to close a position. (You could see that in attached Excel file)


So my goal is to be able to not just import those order (as line items), but also create an entry of the respective trade in TRADES database (as in invoices), so when I open a trade, I could see all order on that particular trade.


How could this be done?