ContributionsMost RecentMost LikesSolutionsRe: Change related field from Record ID to textThanks so much! That is exactly what I needed. ------------------------------ Kandice Bailey ------------------------------ Change related field from Record ID to textWe have several child tables to a single parent table. When it shows the related parent table, it lists it as a numerical value (Record ID). For example, the related location to a specific permit is 14. I would like it to list the name of the related location. I have tried using the record picker option, but it still shows as a number on the default report. Any help on how to do that? ------------------------------ Kandice Bailey ------------------------------ ChangeWe have several child tables to a single parent table. When it shows the related parent table, it lists it as a numerical value (Record ID). For example, the related location to a specific permit is 14. I would like it to list the name of the related location. I have tried using the record picker option, but it still shows as a number on the default report. Any help on how to do that? ------------------------------ Kandice Bailey ------------------------------