Hi all,
I need to store details from objects.
I will store many different objects, potentially up to 1 mil.
Each object has 30 to 40 properties and each property has a value.
So I created 1 objects table so that each object gets an ID.
Then I created 1 properties table that contains an ID, ObjectID, Property and value.
Is this correct? Or should I create a seperate table for each property as well? The properties are now repeated which is not normalized, but 40 seperate tables also doesn't make sense...
And what would be the most efficient way to retrieve certain properties from a specific object?
Lets say I have Object A and I want to retrieve the values of property 1, 3, 5, 6, 7 and 8
It doesnt make sense to make 6 different dlookup calls based on the object ID right?
Thanks in advance!
I need to store details from objects.
I will store many different objects, potentially up to 1 mil.
Each object has 30 to 40 properties and each property has a value.
So I created 1 objects table so that each object gets an ID.
Then I created 1 properties table that contains an ID, ObjectID, Property and value.
Is this correct? Or should I create a seperate table for each property as well? The properties are now repeated which is not normalized, but 40 seperate tables also doesn't make sense...
And what would be the most efficient way to retrieve certain properties from a specific object?
Lets say I have Object A and I want to retrieve the values of property 1, 3, 5, 6, 7 and 8
It doesnt make sense to make 6 different dlookup calls based on the object ID right?
Thanks in advance!