Auto enter calculations?

[Heathbo]

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

[Heathbo]

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

[LiveOak]

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

[Heathbo]

Thank you soo much. You don't know how much work you saved me.

Heathbo