Heathbo Posted October 1, 2004 Share Posted October 1, 2004 How would I go about doing this? What I want to do is have 3 fields (Type, Skew, ID). The "Type" field is a pop-up window with the words (clothes, food, household) in the window. The Skew window is a number that I type in. I know how to do everything above. What I don't know how to do is this Example: When the "Type" field is clicked on and household is selected the letters "hh-" show up in the "ID" field, and when I type in the "skew" field, the skew numbers show up in the "ID" field after the letters that are already there. ie. hh-123456 Hopefully someone knows how to do this. Heathbo Link to comment Share on other sites More sharing options...
Heathbo Posted October 1, 2004 Author Share Posted October 1, 2004 I also need to set it up so the computer will see "hh-123456" as a different number from "fo-123456". So far when I manually enter the info and then try to bring it up through a portal the computer thinks they are the same number and only shows one. Heathbo Link to comment Share on other sites More sharing options...
LiveOak Posted October 1, 2004 Share Posted October 1, 2004 Try this: Type (text) Skew (number) Do you mean SKU? ID (calculation, text) = Case( Type = "household", "hh", Type = "clothes", "cl", Type = "food", "fo", "") & "-" & ID The reason that fo-123456 looks like hh-123456 is that the field it is entered into is a number field, it needs to be a text field. -bd Link to comment Share on other sites More sharing options...
Heathbo Posted October 3, 2004 Author Share Posted October 3, 2004 Thank you soo much. You don't know how much work you saved me. Heathbo Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7273 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