3 Replies Latest reply on Sep 22, 2016 1:58 AM by Johan Hedman

    Automatically enter field contents from another table

    rawsoft

      Good morning all. I would appreciate some guidance

       

      When I enter new record information into fields in a portal, I want to automatically add information into certain fields from data in another table. There must be a simple way to do this but it has eluded me.

       

      Just to elaborate a little, some of the information does not change. In this case, it might be that a segment (in this case, part of a cycle route) has a fixed distance and gradient. This information is contained in a separate table

       

      When I come to enter details of a cycle ride, I want to enter the name of the segment and have it automatically complete the distance and gradient fields based on the static information in the other table.

       

      I have experimented with lookups and relationships but have not yet found the answer. Any assistance would be appreciated

       

      Thanks in advance