Torrwin
asked on
Table of Types Examples
I've got dozens of "type" tables that are mostly identical and I would like to consolidate them all into a handful of tables. (i.e. a table of types)
For example, the tables Permit Type, Employee Type, Line Type, Vendor Type, etc. all have the same basic columns:
X_Type_ID
X_Type_Name
Display_Color
Display_Order
Created_Date
Created_By
Last_Updated_Date
Last_Updated_By
There are a few that might have an additional attribute column, but for the most part they're just an ID and a Name.
Does anyone have a link to an example of creating a table of types, or just advice in general?
For example, the tables Permit Type, Employee Type, Line Type, Vendor Type, etc. all have the same basic columns:
X_Type_ID
X_Type_Name
Display_Color
Display_Order
Created_Date
Created_By
Last_Updated_Date
Last_Updated_By
There are a few that might have an additional attribute column, but for the most part they're just an ID and a Name.
Does anyone have a link to an example of creating a table of types, or just advice in general?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.