Adding a description to a text feild based on a value in another field.

[y2kmental]

Hello all, I am making a dispatch database for a volunteer ambulance organization and in the db I have:

A list of radio codes (aka 10-codes) where each code corresponds to its own value...

example:

10-63 = Responding to location:

10-98 = Available in the area.

When a radio code is selected I would like a description to go into the addjacent text feild with the ability to type further information...

example:

10-63 | Responding to location: QB/63DRIVE for mortor vehicle accident

10-98 | Available in area, from (whatever) area

I already have the feilds set up all I think I need is a script to insert the corresponding description into the text box.

Thanks for you help

[Raybaudi]

Hi

the addjacent text field must have an AutoEnter calc in its option:

Case(

code = 10-63 ; "Responding to location: ";

code = 10-98 ; "Available in area, ";

code = ..... ; "....................";

""

)

[y2kmental]

But how will the "Description" Field know what what selected in the dropdown "Code" Field?

here is a picture

http://home.fhvac.org/images/fm/pic1.bmp

Thank you much.

[Raybaudi]

your picture shows codes that are different from what you said !

They appear to be single numbered...

So I don't know why you said:

10-63

10-98

etc.

BTW: Description field will keep the exact value by the calc above; that calc must be in the option of AutoEnter of "Description"

[y2kmental]

Well the 10 is assumed, in emergency services we use codes called 10-codes, basically its shorthand for terms.

I was just providing the 10 for informative purposes. 63 and 98 may make no sense to people.

[Raybaudi]

If those codes are more than a few, it's better to make a new table of CODES with 3 field:

ID

CodeNumber

Description

and a relationship from:

YourTABLE::CodeNumber = CODES::CodeNumber

So, at the end, no calc will be involved.