I have a database that I created. When duplicating the record it will duplicate all of the record but some of the fields are blank and the portal information is blank. Can someone help?
I assume you have a primary key field that is entered somehow: either as a serial or UUID. Is that correct?When you duplicate a record this field with the auto-enter calc will change. This means that any related records to the first record will not be related to the 2nd duplicate record.
Does that make sense? You have to do something: either change the foreign key of the related records to the new record's primary key. Or you have to duplicate the child records and assign these new records the foreign key (which doesn't auto-update).
Let me know if you need some clarification.
In a Parent-with-children set of record(s) you have TWO tables. If you duplicate a record in the parent, it does NOT automagically duplicate the child(-ren).
If you search this forum for 'duplicate parent and child', you'll find many suggestions. I prefer this tried and true demo:
NightWing Enterprises - Duplicate Hierarchy v2.0 for FileMaker
(yes, the file format is the same, so all versions >=13 will open the file just fine!)
Hi there. Checking in to see if you were able to resolve your issue? If so, could you mark an answer as correct so that others may know how you got this taken care of. Thanks
I have been trying to duplicate my record but have not been successful. I have attach my scripts and table in my relationship. Can some one take a look and give feedback.
Retrieving data ...