I was therefore thinking of a Properties table with Property and Description fields with a many-to-many join to the Assets table (some properties would be shared between assets).However this opens up a few issues, ideally the properties should have different types for example some would be numbers, others would be text.Any input into the design would be very useful :)