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

Outcomes