Combo Box Selection and Values

[flavioso]

Hello. I have 2 tables, one called tblDETAILS and another table called tblQUALIFY. In both tables, I have 3 fields, fldCOMP, fldQUALIFY, fldACTIONS. On my form for tblDETAILS, I have a combo box which has all three fields from tblQUALIFY. When the user selects the fldCOMP column, it has the fldQUALIFY and fldACTIONS attached to it.

What I am trying to achieve is to store these values in each of the columns from the combo box into a table field.

For example, the combo box lists 3 columns with a hidden key column:

Ferris // Good Quality Lead // Send Samples Catalog and contact Salesperson

When the customer chooses this from the Combo box bound to tblQUALIFY, I would like it to populate fldCOMP, fldQUALIFY, and fldACTIONS in tblDETAILS set to the current record.

I thought about performing cascading combo boxes, but the actual values need to be stored for later use. Does anyone have any suggestions on how to achieve what I am trying to do?

I appreciate any help in advance.

Bradley

 

[MarkK]

You almost never need two tables with the same structure. Like you don't need a PendingOrders table AND a CompletedOrders table, rather you need a single Order table that contains a Status field. To work with Pending orders you write a query with a "WHERE Status = 'Pending'" clause.
If all you need to do is identify records that "qualify" then add a Yes/No IsQualified field to your single table, and give your users a check box to modify this status. This is a much simpler approach if it will satisfy your requirements.