I'm very new to Filemaker but it seems like it's going to be very useful.
For my first project I have a spreadsheet which has the equivalent of 1 invoice number and customer details per row and then on the same row, following the few columns of invoice header data, it then has a series of products listed 1 per column.
On each row of the spreadsheet is the quantity of each product on the invoice which is in the row. I would like to be able to import the first few columns into an invoice table. I then believe I will need a table for the products (from the Column headings), and then finally an invoice lines table containing the link to the original invoice number, another link to the product table item and then inserting the quantity required from the original spreadsheet.
Is this easy to do and are there any examples I can follow? Thanks