Hi, I am attempting to create a database that holds data about steel.
One characteristic about the steel in this database is its dimensions.
Some sections of steel only need two dimensions (Length and Breadth), while other sections of steel need 3 dimensions (Length, Breadth and Height).
In this table about the steel, I have a field that is named "Dimensions", I have input the data in this field as "00 x 00" or for 3D steel pieces "00 x 00 x 00".
The problem is, the data type for the field of "Dimensions" is Short Text and so I currently have no way of validating the data being typed into these boxes under the field "Dimensions".
However, I want the data validation for this field to be dependent on another field in the table- "Type".
In the "Type" field I have a Lookup Wizard that I have set to have 10 options.
What I am not sure is possible is to be able to validate the "Dimensions" field depending on what is selected in the "Type" field from the dropdown box.
For example,
If "Flat" is selected in the dropdown box under the "Type" field, then the "Dimensions" field would only allow "00 x 00" data to be entered.
However,
If "Channel" is selected in the dropdown box under the "Type" field, then the "Dimensions" field would only allow "00 x 00 x 00" data to be entered.
Is this even possible and does anyone know how to do it?
This would be a great help and it is extremely appreciated.
Thanks
One characteristic about the steel in this database is its dimensions.
Some sections of steel only need two dimensions (Length and Breadth), while other sections of steel need 3 dimensions (Length, Breadth and Height).
In this table about the steel, I have a field that is named "Dimensions", I have input the data in this field as "00 x 00" or for 3D steel pieces "00 x 00 x 00".
The problem is, the data type for the field of "Dimensions" is Short Text and so I currently have no way of validating the data being typed into these boxes under the field "Dimensions".
However, I want the data validation for this field to be dependent on another field in the table- "Type".
In the "Type" field I have a Lookup Wizard that I have set to have 10 options.
What I am not sure is possible is to be able to validate the "Dimensions" field depending on what is selected in the "Type" field from the dropdown box.
For example,
If "Flat" is selected in the dropdown box under the "Type" field, then the "Dimensions" field would only allow "00 x 00" data to be entered.
However,
If "Channel" is selected in the dropdown box under the "Type" field, then the "Dimensions" field would only allow "00 x 00 x 00" data to be entered.
Is this even possible and does anyone know how to do it?
This would be a great help and it is extremely appreciated.
Thanks