1 Reply Latest reply on Dec 15, 2009 9:18 AM by ninja

    getting field to transfer data from one layout to another

    kilbot

      Title

      getting field to transfer data from one layout to another

      Post

      I have a layout using a table I called dataentry in which I will include contractors on a construction job. I would like to have a table set up with all the names of the contractors and their information (address, phone...) and then when I am entering the info on the dataentry page the contractors info would automatically fill in. I can have up to 20 contractors on a job and wonder if I could do this using a portal to save room.

       

      Help 

       

      Thanks

        • 1. Re: getting field to transfer data from one layout to another
          ninja
            

          Howdy kilbot,

           

          Check out this thread: 

          Printing Award Certificates - HELP!!

           

          You would need a related table of contractors that contains the contractor info.

          if you have 20 on the job, a portal would be a good way to list them.

           

          Consider further:

          Have a Job table

          A "Contractors on this job" table linked to "Job" by JobID (one to many relationship)

          A "Contractor Info" table linked to "Contractors on this job" table by ContractorID (many to one relationship)

           

          Job Table ----< Contractor/Job Table >----- Contractor Info Table

           

          On the layout based on "Job", have a portal based on "Contractor/Job"

          Put fields from "Contractor Info" in the portal along with a ContractorID dropdown to make the link.

           

          Does this sound like what you're after?