two column combo box (A2K)

[Night]

OK, I have a simple question I'm sure but I have done all I can think of to try and get this to work. I have a combo box that has to columns of information in it. Each column represents a different field in a table. Now what I can seem to get it to do is record the second column as well as the first into the table. Is there anyway to do this? Thanks for the help.

[tmorken]

Sure, using the column property you can set the second field value equal to any column of a chosen combobox row

FieldValue = ComboboxName.Column(Column#)

However, be aware that the FIRST column number is "0" , the second is "1", the third is "2", etc.

There is more to this property, so check it out in Help.

[Night]

yeah I knew I was retarded. For some reason more complex things I can figure out, but the most simple of concepts I have trouble with. Ah well it works now. Thanks.

[MarkLiquorman]

Why are you recording both columns of data in a table? You should be recording only the bound column.

[Night]

well the reason is this. The way reocrd management works here there is a number corosponding with every Record Series Name. There could be multiple numbers for the same Series name because it could be a different department that has that name as well. So I needed to put the numbers by the name so people would know. Now, I needed the second column to be stored as well because if it wasn't then I wouldn't be able to pull a report by the number which some people very well may likely do. That is why I did what I did.

[charlotte]

You're going about it backward. If there can be multiple numbers for the same series name, then each of those records should have its own unique key and *that* is the value you should be inserting into your record.

[Night]

I understand that Charlotte. I thank you. But this is how they wanted it. They never do seem to listen to my advice. Either way though it's done so I don't have to mess with that DB again.

[charlotte]

What users want is appearances. You can't let that dictate the shape of the data or the methods used. My users are NOT allowed into tables or into the database window, so I can show they whatever they want to see but I don't let them look at what's underneath.