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