Help with importing an old repeating field based DB into new tables based one
Not sure but I'll probably have to script this or something. Hope I can explain this one...
I have an old database that was made using repeating fields. Unfortunately (for me) it is a sales slip database with information pulled in from all kinds of other files. So far I've been able to split the repeating fields into the line items table, the customers into customers and have got almost all the data to pull itself in. Almost....The problem I'm still having is with the portal in the new sales slip table. It shows the related product that was bought, but doesn't show the price info. I'm guessing this is because the portal is set up to pull info in from the products table and not to fill from the line items table. So that's the last part of the puzzle that needs to be completed.... I need the portal to use the related information from the line items table. I'm guessing this will have to be done with a script and set field or something, but not sure. Hope someone knows the answer (-: