I need to export records from two different .fp7 files to one another. For example, abc.fp7 is a note taker file with 500 notes. I need to export those notes to 123.fp7 which will be only 1 record housing all 500 notes. Is there a way to make a container to export these notes from one another automatically? I also want this to be only for certain accounts with the proper privledge to access it. Thank you very much for your time

Is there some reason you can't keep the notes in the note taker table? If there is something tying them together, you can use a relationship from a parent table, and show the notes through a portal or something.

The 123.fp7 that is going to house the notes into one log is meant to be more for the back-end and only viewed by a few individuals with privledge. I just need to make it more presentable and cleaner so it is easy to read through without switching to multiple databases.

If that's the back end, then presumably there's a front end and something to tie them togther. Use the same idea to show the 123 records through a portal on whichever layout you wish.

Limiting access is a separate issue that can be solved in a variety of ways.

Unfortunately, it's hard to be more specific without having information about the structure and the specific goals.