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?