Importing Records with a Loop
I need to set up a script to import records. I'm going from a one table db to multi tables db so while importing I need to relate records with scripts I already have in place for making a new related record in another table. My basic question first is can I import the records one at a time and have them go thru the script steps then when finished it goes to the next imported record or do I need to import them all into a temporary table first and loop thru it?
Further question will be on the new db I have a popup list to display names but it relates to a name ID from another table. If the imported record name field is "John" how do I tell that layout to set that field since it needs the name ID to actually relate to the foreign table?