AnsweredAssumed Answered

importing to multiple tables

Question asked by on Feb 19, 2009
Latest reply on Feb 23, 2009 by hiatts


importing to multiple tables


I'm just getting started with FM and could use some help.  Can someone point me in the correct direction.  I need to import sales orders into my filemaker DB.  The sales order in my FM DB consits of a Header table and an Order Lines table.  My text file from the external device capturing the sales order can be coded to identify what is a Header record and what is an Order Line record.  For example I can make a Header record begin with H and a Order Line record begin with L.  The records for both tables will contain the key for the Order table to tie the lines and header together.   Could a script allow me to import multiple tables and identify what records go to what tables?  A couple of hints to get me started would be greatly appreciated.  Thanks.