I’m new t Cuba and I’m trying to find a way to recreate a functionality that I have in my old access application.
So what I have is one table that contain dictionary entries with fallowing columns
- Type of dictionary
- Value in english
- Value in language 1
- Value in language 2
- Reference to upper level dictionary (used for situation where I have two drop downs where on is filtering other)
- Active / unactive marker
This table is referenced in multiple other tables but without use of foreign key just by ID.
Each dropdown in application is selecting proper data set from this table based on user lanaguage and type of dictionary.
My first idea was to recreate this by creation of multiple enums in Cuba but then I have stuck on multi level dictionaries (2 levels to be exact).
What would be best option to solve this ?
I need also option for user to manage values (names) in dictionary. Would it be better to use entity approach or enum approach ? and how to build then drop downs that depends on each other ?
Thanks for the help.