Multiple columns in Combo Box to DB

[jdbegg]

I have what probably is a simple problem. I've been able to select and display in my form the two columns I want from a lookup table. One column holds the Product Code, the other has the Product Description.

The problem I need solved is taking the two values and inserting them into their respective row/column in the table the form is bound to. I can only get the Product Code to insert at the moment.

Thanks in advance.

JDB

 

[dcx693]

Do you have product code and product description on two separate combo boxes? If so, just bind the two combo boxes to their respective fields in the table.

 

[Rich]

You only need to store the product code or the pk for it from the look up table, use queries to return the product description when outputing to a report

 

[jdbegg]

dcx, No, I just have the one combo box that displays the values from two columns. The pk is hidden.

Rich, you're exactly right about the pk. I had forgotten about it. I was going to use the Product Code as the pk, but found that there was one duplicate code with a different description in it. Not a happy camper.... but, what can I say?

Thanks for the help.

JDB