Transfering information between two different .fp7's

[jsoren]

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

[Ender]

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.

[jsoren]

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.

[Ender]

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.