Cascading Combo Box

[ijamal]

Dear members,

I have a form with 4 Combo boxes bound to fields in 4 tables;

1) Oblast Name
2) District Name
3) Jamoat Name
4) Village Name

The selections work fine. Cascade works from Oblast to Village Name. My question is ;

Currently the ID's of the bound columns are stored in the tables instead of the corresponding data. For example for the Oblast name; I have the value "3"=" rather than "Khatlon" for District_Name, I have "223", rather than "Muminobad".

Is there way to capture the names of the respective places rather than storing ID's in the table?

Thanks in advance.

Irshad

 

[neileg]

The data is being stored correctly, according to normalisation rules. If you need to show the names in a report or form, just join the relevant tables into the underlying query and use the field that holds the name from that table.

 

[ijamal]

Hi Neil,

Thanks for responding. Actually, I do not need this information in a form or report. My requirement is that the "place" values of the Oblast, District etc... be stored in the table not the ID's. This is needed as I will be exporting data to a Geodatabase (ArcGIS table). The values that are exported show up as numbers not as names and so this is the real issue.

Thans for taking the time to respond.

Regards,

Irshad

 

[neileg]

Just create a query that joins the relevant tables and export the query. Any place you would use a table, you can use a query.

 

[Laurentech]

In the properties for the Combo Box control, set Bound Column to the column that holds the name. For example, if the source where the combo box gets it's data from has two fields - ID, and PlaceName, having bound column set to 1 will store the ID and having bound column set to 2 will store the place name.

I hope that's understandable!

Larry

 

[neileg]

In the properties for the Combo Box control, set Bound Column to the column that holds the name. For example, if the source where the combo box gets it's data from has two fields - ID, and PlaceName, having bound column set to 1 will store the ID and having bound column set to 2 will store the place name.

I hope that's understandable!

Larry

Understandable, but still denormalising the structure when there is no need!

 

[ijamal]

Thanks

Dear Neil and Larry,

Thanks for your responses. Neil - I have created a query that joins all the relevant tables and gives me the output I need. However, what I need to accomplish is to have a Water_System table in another Access DB (A GIS Geodatabase to be more specific, let's call in DBA) append and update records in the Water Systems database (DB B).

The problem is that the Oblast, District and Jamoat names are of type text, where as the correponding fields in water systems database are of type number.

Larry - I did try to bind the field containing the name of the places but that does not save the record in the database. When I select from the combo box (4 choices), the selected item does not show in the combo box and consequently nothing is written to the database.

Please see attachment for illustration.

Thanks for your help.

Irshad

 

[Pace]

ijamal with all respect you could carry on forever here,

If your original question is answered, please start another thread for a new one, but as a tip you really need to read a book on database design because you seem to be confusing yourself and I really think you need to learn how to do this properly, for you ;-)

Why dont you just add another field to the other database that holds the text as well as the ID as you already have vice-versa, regardless of the number then you can always pull what it is.

google: basic database design ;-)

hth

Pace

 

[ijamal]

Thanks for the tip

Dear Pace,

I appreciate your guidance in this matter. I will certainly try and do some more reading on database design. I have only recently started getting my feet wet in Access and am quite aware I do have a great deal of learning to accomplish.

Again many thanks.

Irshad

 

[Pace]

no problem ijamal!

Im by no means having a dig, its just I can see you have the right kind of idea and I think if you do this for yourself, you'll learn an awful lot and find your new goals much easier!

Good luck!

Pace