Field Values Automatically Updating Other Fields

  • Thread starter Thread starter Bfunk
  • Start date Start date
B

Bfunk

Can a value in one field be determined & populated as a result of a
certain value in another field?

Table = Facility Information

1. Field Name = Building Status
Value 1 = Open
Value 2 = Closed

2. Field Name = Building Function
Value 0 = Closed
Value 1 = Elementary School
Value 2 = Middle School
Value 3 = Office Building
Value 4 = Sporting Facility
ETC...

I would like the table to automatically update the "Building Function"
Field to a value of "0" when the "Building Status" field value is "2"
or "Closed."

How can I do this? Please help!
 
if the values you posted are the actual values used in your table, then the
BuildingStatus field seems redundant to me. given that the BuildingFunction
has a "Closed" value available for use, then by default any building that
does not have a "closed" value in BuildingFunction, is an "open" building.
and that being the case, you can query the BuildingFunction field to find
all closed buildings OR find all open buildings, if you wish. so a separate
BuildingStatus field appears to be unnecessary.

hth
 
That's what I figured. Thanks for your help. I will just use the
Building Function as you suggested.
 
Back
Top