Combining data into records and image container from path
I have an Excel file (or csv) that has data setup like this:
I need to get that into a filemaker db, which I have setup as Table1: last,first,id,rm#,data
Now, I know the obvious, I can't just import that csv into my db as it creates 3 records for jane, 3 for john, etc...Can anyone give me a concise yet thorough (oxymoron?) way to create the tables I need to get that data into a db so that when I browse to Jane's record, it shows a field that lists her last name, first name, id, rm#, data1, data2, data 3?
The id's will always be particular to that person. The data is basically a data1.jpg, data2.jpg file.