Imported data to Portal Question
I'm doing ODBC imports from one database to File maker.
I have one field importing from the 'other' database that contains several lines of important data (in the one text field),
3000 X (UNIQUE_ITEM_CODE) (ITEM_DESCRIPTION)
3000 X (UNIQUE_ITEM_CODE2) (ITEM_DESCRIPTION2)
3000 X (UNIQUE_ITEM_CODE3) (ITEM_DESCRIPTION3)
and so on.....
This field is imported via a match field called JOB_NUMBER
What i want to do is to be able to seperate these lines and put them into a portal as individual records all relating back to the JOB_NUMBER field.
I there a way I could convert this text field containing (let's say 3) lines of data into a Portal that would beable to display these 3 lines of data as individual records?
Any help would be amazing!