I'm having an issue with moving records between tables within my file. I've already implemented this successfully in one instance, setting the source by performing a find within one layout then setting up an import to another layout from the same file that's being worked in.
However when I try to do this using the same method between another two layouts I'm struggling to get the source to set up correctly as filemaker appears to keep setting the source as the same as my desired target layout. Any ideas as to what might be causing this?
I don't know whether it's relevent but the layout I'm moving the records from was duplicated from the layout that I'm moving the records to (which is appearing as the source as well as the target). However I have changed all of the fields on it to the ones appropriate to the new table as well as linking the layout to the new table as well. There's nothing I can see anywhere that would indicate that the layout is in any way still associated with the table which is behind the layout that I originally duplicated. Could this be the problem? Would I be better starting from scratch?
If I turn off the perform without dialog option I can then manually select the source without issue however this is unsatisfactory for the final solution.