Linking Location to the State, County and City fields on the timecard

Hello Everyone,

On our timecard layout, we have a location, state, county and city which the last three override the payroll costing for the time that is entered. The state, county and city are using the seeded geo codes and are connected (where the list of values will narrow down for the county based upon the state and the city will be narrowed down based upon the county), but we would like them to be dependent upon the location that is entered. When a location is entered, it should then auto-populate the state, county and city fields that are associated