2 Replies Latest reply on Jun 3, 2015 11:10 AM by philmodjunk

    Importing data into 3 tables?

    gremlin9297

      Title

      Importing data into 3 tables?

      Post

      Hi again,

      I have a data file that needs to be imported into 3 tables. My Main table contains employe information, the next contains information for vacation and sick time, and the third contains time for days not used. There is a  main layout that contains portals for each of the other tables. Basically.. 

      Employee Layout

      --Vac_Sick Portal--- 

      --Unused days Portal--

      The import has information that needs to be spread across these three tables. Im assuming it will have to be done with separate imports, though when I try to do that the other table are greyed out even when on a layout for that specific table... any help would be appreciated. Attached is the relationship I currently have set up for the three tables.

      THANK YOU!

      Relationship.png

        • 1. Re: Importing data into 3 tables?
          TKnTexas

          Do the Employee Record import first.  Import the fields it gets first.  Go to a layout for each of the other two tables, do the import for those fields.  It is three separate imports, it is just that you are using one source.  

          • 2. Re: Importing data into 3 tables?
            philmodjunk

            However, your relationships do not look like they are set up correctly. The fields ending in "FK" should have "crowsfeet" in the relationship line that connects to them. This indicates that you have set up those fields either to auto-enter a serial number or they have a unique values validation specified and that should not be the case here.