i have 2 tables that have a field with name 'state_of_record' in table 1 it is as state_of_record1 and in table2 it is as state_of_record2, this field shows State of each records in these tables the value of this field is 1,2,3,5 :
1 means the record is on progress.
2 means the record is completed
3 means the record is Completed and Submitted
5 means the record is Confirmed
these description are common for state_of_record1 and state_of_record2.
actually state_of_record1 and state_of_record2 have same nature and shows state of a record.
i want to know can i have a description field that both of 'state_of_record1' and 'state_of_record2' use it?
maybe it is such a ridiculous question but i want to know is there a way for doing this?