DA Query - Create attribute SQL ENUM but Modify as String

[AG]

Here is the usecase -

During New Account creation we have few DA in parent - child combination. Based on Parent attribute selection Child attributes will get pre-fill. Both Parent and Child are of type SQL ENUM.

There is a requirement that if Parent attribute is not selected then the requestor should be able to enter values for child DA. Since Child DA is of Type SQL ENUM it does not allow manually typing values.

What are the available options to implement this usercase.

PS - Child DAs are mapped to Account Column.

[rushikeshvartak]

Create another attribute type string and ask user to input the value 

[AG]

@rushikeshvartak  - Yes, I am planning to do so, my only question is, in my initial post in PS - I mentioned I am mapping it to an Account column. If I create another String type DA for manual entry, then I should use the same Account column for mapping that I am using for SQL Enum type DA. Correct?

Will that cause any issue with data inconsistence?

If not then, I can use show hide feature to toggle these DA attributes.