On my form, when opened as NewForm, I have a dropdown that is a lookup field in my sharepoint list, when an option is selected, i have a textinput field which will populate specific data that is related to the chosen item in dropdown:
C Code is selected and Care is displayed in the Subject Name (which is view only field).
When the form is opened in Edit mode, i want it to display the saved data so in example above it would display 'Care', but if the C Code was to change, then I would like the Subject Name to change as well, but i am struggling to get this to work.
On the Default property of the Subject_Name datacard I have:
If(Form1.Mode = New, LookUp(LDR_SQA_Exam_Dates, C_Code = DataCardValue1.Selected.Value, Subject_Name), ThisItem.Subject_Name)
On the Default property of the TextInput, I have:
Parent.Default
How can I amend this so that it displays the saved Subject_Name but if the C Code dropdown changes, the Subject_Name field will update and save the new data when submitted?
