Hello,
If a user creates a record in the vehicle parts table, then a column Spare Tires from the 'Checks' entity needs to be auto-populated with a column 'Spare Wheel' in the vehicle parts table'. Existing 'Spare tire' field is a dropdown; therefore, where there is no information recorded within the vehicle parts for a 'Spare Wheel', this should be kept as a dropdown field with the same options present. Otherwise, it should display the value in single-line text.
Is it possible to change a choice data type to single-line text in a form as per the above scenario? If yes, can anyone provide me with the steps to do it?
Thank you for your assistance!
