Crow Canyon Software Forum
Lookup columns (Access data from Parent List)
Quote from skigeek on February 7, 2023, 5:05 pmCome on... This cannot be so difficult. I am inserting a row in my child list (Hours). It has a lookup to the parent list (Staff). I want to retrieve some information from the partent list to populate the child by using the StaffEmail. Please help. I have been stumpted for over a week.
Staff List (Parent List)
StaffEmail Single Line of Text
ManagerText Single Line of TextHours List (Child List)
Staff Lookup (Back to the Parent StaffEmail)
Staff:ManagerText Lookup
Hours Int
Come on... This cannot be so difficult. I am inserting a row in my child list (Hours). It has a lookup to the parent list (Staff). I want to retrieve some information from the partent list to populate the child by using the StaffEmail. Please help. I have been stumpted for over a week.
Staff List (Parent List)
StaffEmail Single Line of Text
ManagerText Single Line of Text
Hours List (Child List)
Staff Lookup (Back to the Parent StaffEmail)
Staff:ManagerText Lookup
Hours Int
Quote from Prakash Arya on February 13, 2023, 2:36 pmHi @skigeek,
Looks like your requirement is to populate 'ManagerText' column value from parent list to a column in child list when user selects the 'Staff' lookup column in child list new/edit form. For this, you do not need to create additional lookup column 'Staff:ManagerText'. Just create a normal single line of text column in the child list. Refer to below video to do the NITRO lookup column settings to auto-populate column value from parent list to child list. In this case, you will have to map 'ManagerText' column to new single line of text column in the child list.
https://www.crowcanyon.help/article/how-to-setup-lookup-settings-in-nitro-forms/
Please give it a shot and let us know if you need further assistance.
Thank you
Crow Canyon Team.
Hi @skigeek,
Looks like your requirement is to populate 'ManagerText' column value from parent list to a column in child list when user selects the 'Staff' lookup column in child list new/edit form. For this, you do not need to create additional lookup column 'Staff:ManagerText'. Just create a normal single line of text column in the child list. Refer to below video to do the NITRO lookup column settings to auto-populate column value from parent list to child list. In this case, you will have to map 'ManagerText' column to new single line of text column in the child list.
Please give it a shot and let us know if you need further assistance.
Thank you
Crow Canyon Team.