Originally Posted by
ArviLaanemets
In tblAssets, you have a field Type. Now you need a table, where all those various types are defined:
tblTypes: Type (I advice to have it an integer value), TypeName;
I assume you have a very wide selection of various equipment, and every type of it is charactierized with different set of various properties. So:
tblAssetProperties: AssetPropertyId, AssetType, PropertyID;
tblProperties: PropertyId, PropertyDescription; PropertyValueType (PropertyValueTypes may be e.g. 1 for integer, 2 for double, 3 for boolean, 4 for short string, 5 for long string, etc.)
tblAssetPropertyValues: AssetPropertyValueID, AssetId, AssetPropertyId, IntegerValue, DoubleValue, BooleanValue, ShortStringValue, LongStringValue, ... (Depending on PropertyValueType of property, one of value fields is filled. Another possible way is to have separate tables for every PropertyValueType. With either of solutions, on form where property value(s) is/are edited or displayed, only value of type determined by PropertyValueType is visible and accessible).