1 2 Previous Next 25 Replies Latest reply on Aug 9, 2011 10:28 AM by mgores

    importing records from a file that match an ID in a different table

    mgores

      Title

      importing records from a file that match an ID in a different table

      Post

      I am trying to import records from several form tables in a hosted file to several form tables in a local file, based on a metch to a field in a main table of the local file.  There can be 0 to many records from each table.  The hosted file contains forms from many jobs and the local file is for one jobs.  I would like to import all of the form records from the hosted file that are related to the ID field of the local file, with the idea that if there is data for a particular form a record is created, but if there is no data for that form no record is created.  The local file will start with one record in the main table where the user enters the number in the ID field and no records in the other tables.  Then a script will import the records from the hosted file and creating records in the other tables as needed.

      Is it possible to have a match field when there are no records in a table?  Could each table have a global field (with no records present) that acts as the match field?

        1 2 Previous Next