AnsweredAssumed Answered

Automatically enter field contents from another table

Question asked by rawsoft on Sep 22, 2016
Latest reply on Sep 22, 2016 by Johan Hedman

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