Exporting & importing records
I'm designing a database that will have several related tables. The DB will be 'standalone', ie. not server-based. Users would each have a copy. Before I go far I'd like to work out how best to enable users within the same organisation to transfer records between themselves, ie. export the record from J Smith from user 1 so that user 2 can import and use the record.
Would I be best having a kind of 'archive' table the keeps all the vital info?