alphanitrate Posted October 4, 2007 Share Posted October 4, 2007 I have a database of products which has a sub class identifier. I also have a bunch of safety warnings in value lists. What I would like to do is to have certain warnings from the lists activated based on it's sub class identifier. ie. subclass =210 value list 1= wear gloves active (rest inactive) value list 2= explosive rest inactive) value list 3 = do not use in confined spaces etc.rest inactive) I'm not sure how i should even start... Any help would be greatly appreaciated. Link to comment Share on other sites More sharing options...
bcooney Posted October 5, 2007 Share Posted October 5, 2007 How about a table "SubClassWarning" that stores subclass and safety warnings? __kP_PrimaryKey _kF_SubClassID _kF_WarningID On a layout based on a Subclass TO, create a portal to this table (relationship _kP_SubClassID = _kF_SubClassID. Create one value list, created from your safety warning table (__kP_WarningID, Desc). Back in the portal, set the _kF_WarningID to use this value list. Now, back to Products. When you set the subclass for the Product, that is, Products:_kF_SubClassID, you can have a text calc field that gets all the safety warnings (List function) for this Product by using a relationship from Products to SubClassWarning by _kF_SubClassID. Link to comment Share on other sites More sharing options...
alphanitrate Posted October 5, 2007 Author Share Posted October 5, 2007 thanks for the idea - i'm going to start working on that right away. One question - it seems that i would assign warnings based on the sub dept, my question is will this allow users to activate/ deactivate the other warnings (about30) ? Link to comment Share on other sites More sharing options...
bcooney Posted October 5, 2007 Share Posted October 5, 2007 In the Sub Dept form, where you "attach" the warnings, you wouldn't create records in the portal for the warnings that you do not want associated with the Sub Dept. There is no activate/deactivate. Link to comment Share on other sites More sharing options...
alphanitrate Posted October 6, 2007 Author Share Posted October 6, 2007 ok thanks - i'll let you know how make out. Link to comment Share on other sites More sharing options...
bcooney Posted October 7, 2007 Share Posted October 7, 2007 Had time for a demo. Is this the functionality you were looking for? Topic_190546.zip Link to comment Share on other sites More sharing options...
alphanitrate Posted October 9, 2007 Author Share Posted October 9, 2007 That is a great solution to this problem. Thanks for going to all the trouble of creating the sample up for me. I understand it more now. It's not exactly what I was looking for. Here is a copy of what I was originally looking for. The light green field in the top IS_CLASS would activate/ deactivate the check boxes on the packaging tab. I think that I will have to use your method instead - thanks once again. Pkg_Copy.fp7.zip Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6135 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now