Jump to content

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


This topic is 5766 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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"

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 5766 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.