Newbies lisalem Posted June 6, 2001 Newbies Share Posted June 6, 2001 My data entry folks often duplicate records as only small portions of info need changed. How do I get all portal information to duplicate into the new record? Link to comment Share on other sites More sharing options...
Chuck Posted June 6, 2001 Share Posted June 6, 2001 It is rather complicated to this this. Create a couple of global fields in the parent database, gOld_ID and gNew_ID. Create a couple of self-join relationships in the parent database for each of these fields to the ID field in the database. Also create a constant relationship in the child file to the parent file. Then use something like this in the parent database. Set Field [ gOld_ID, Record_ID ] Duplicate Record/Request Set Field [ gNew_ID, Record_ID ] Go to Related Record [ Parent_File~gOld_ID ] Go to Related Record [ Show, Child_File ] Perform Script [ Sub-scripts, External: Child_File (Duplicate Records) ] In the child file, create the following script for Duplicate Records Unsort Loop Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8374 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now