Traditional Culture Encyclopedia - Hotel franchise - An Access data is constructed, and the form uses the regional three-level linkage menu, but it cannot be done. Ask the heroes for help!

An Access data is constructed, and the form uses the regional three-level linkage menu, but it cannot be done. Ask the heroes for help!

Here's the idea

1. Get the list of provinces.

The last four digits of where are 0000.

2. Know the province code and get the city code.

The last two digits are 00, the first two digits of the county are equal to the first two digits of the provincial code, and the provincial code is different from the provincial code.

3. Know the city code and get the county code.

The first four digits of where are the same as the province code, but the county code is different from the city code.