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.

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))

 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.

Sorry for replying late, but thank you very much.