Instead of making 'close to double' Domains I'd like to be able to do the next:
Domain:
- "document_types"
- 1- Purchase Order
- 2- Sales Order
- 3- Invoice
- 4- Picture
- 5- Kick off Document
- 6- Financial Summary
So the case would be:
I have a Documents table with a column "document_types" with this domain.
As example there will be 2 views, where you can add Documents on different ways.
So view 1: I want to be able to add Purchase Orders, Sales orders and Financial Summaries
and in view 2: I want to be able to add Invoices, Pictures, Kick off Document and Financial Summaries.
To achieve this i would have to make 2 more domains for view 1 and 2 where I'll also have to make sure the database values are the same as in domain "document_types".
Right now it takes:
-1 Extra time
-2 The maintainability of these columns/domains are harder, because you need to make sure they are in-line with each other.
What do you guys think?