Jump to content

Help With Field


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

Recommended Posts

Hi All,

 

Having a problem and just can't get my head around it. 

 

I have a Field called 'Department' with a drop down box. In this field is different departments ie; Chemistry, Physics and so on..

 

What I'm trying to figure out is, I want something that when I select a department , lets say Chemistry for example. Is there a way for an abbreviation for 'Chemistry', ie; 'CHEM'  to show in another field ?

 

Thank you. :)

Link to comment
Share on other sites

The abbreviation field could be a calculation field:

Case(
     YourTable::Department = "Chemistry"; "CHEM";
     YourTable::Department = "History"; "HIST";
     //etc
)

Or, if the abbreviation is always the first 4 letters of the department

Upper(Left(YourTable::Department; 4))
  • Like 1
Link to comment
Share on other sites

 I want something that when I select a department , lets say Chemistry for example. Is there a way for an abbreviation for 'Chemistry', ie; 'CHEM'  to show in another field ?

 

I would suggest adding (if you don't already have one) a table of Departments, with (at least*) fields for Name and Abbreviation. Then display the Abbreviation field from the related record in the Departments table.

 

--

(*) Ideally, you would use a DepartmentID as the matchfield, so that your relationship doesn't break if a department gets renamed.

  • Like 1
Link to comment
Share on other sites

This topic is 2844 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.