AnsweredAssumed Answered

Combining data into records and image container from path

Question asked by jla_1 on Sep 2, 2009
Latest reply on Sep 4, 2009 by TSGal

Title

Combining data into records and image container from path

Post

I have an Excel file (or csv) that has data setup like this:

 

doe,jane,100100,12,data1

doe,jane,100100,12,data2

doe,jane,100100,12,data3

doe,john,100101,11,data1

doe,john,100101,11,data2

doe,john,100101,11,data3

vandelay,art,200201,10,data1

vandelay,art,200201,10,data2

vandelay,art,200201,10,data3

 

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.

 

Thanks.. 

 

 

Outcomes