Script for Duplicating a record with a portal
Hello, I am using FM 10 on Windows XP.I am fairly new to the program but I am trying to learn as I go along.
Let me describe what i have. i have created a database with a one to many relationship I have a parent database the has a portal for children data. each has its own auto generated id number on their individual tables.
Next year we need to duplicate the records to update them with any new information. I do understand I have to create a script to preform the task but every time I try it still doesn't duplicate the children data in the parent table or in the related table. Please help!