Import a recordset or link fields? Kevin 05.06.2006 16:06:02 What is the best way to accomplish this? I would like to import/export or copy/paste a recordset with related data in 5 tables from one database in Access 2002 to another database in Access 2002. Or...would I be better off linking the tables? My thought was to base it on a field in the first database called JobNumber. When that field is null, it would not be linked, but when a value is entered (example: 06-5768) it would allow the link to take place? Any help or direction is appreciated!

Re: Import a recordset or link fields? John Nurick <j.mapSoN.nurick[ at ]dial.pipex.com> 05.06.2006 20:34:19 Hi Kevin, Use linked tables unless there's a specific reason not to. On Mon, 5 Jun 2006 09:06:02 -0700, Kevin <Kevin[ at ]discussions.microsoft.com> wrote: [Quoted Text] >What is the best way to accomplish this? >I would like to import/export or copy/paste a recordset with related data in >5 tables from one database in Access 2002 to another database in Access 2002. > >Or...would I be better off linking the tables? My thought was to base it on >a field in the first database called JobNumber. When that field is null, it >would not be linked, but when a value is entered (example: 06-5768) it would >allow the link to take place? > >Any help or direction is appreciated! -- John Nurick [Microsoft Access MVP] Please respond in the newgroup and not by email.