Search results

That is more or less how I have it structured. My problem/concern though is how to store information about the attributes that is of varying data types. For instance, the way I'm currently working is something like: tblAttributes ID_Attr - AutoNumber (PK) AttrName NumericAttrValue (Double)...

Sure, thanks for the response. It would be something like: Part -> Front Panel Attributes (Current): Length -> 100 -> mm Width -> 50 -> mm Thickness -> 2.5 -> mm Material Type -> Steel (where the first three will be stored just as a number, not with the unit of measurement - we only use mm for...

Hi All, I'm working on putting together a MS Access based Database at work and have a bit of an issue. We've got "Parts" that I'm trying to describe in Access. Ultimately the descriptors for these parts frequently change. Right now we may have some and then two months from now there are new...