Howto save recds from 1 table to an other

[Mary]

Hi,

TableA is linked to TableB. On a Form, I use a combobox from TableA to
search for an existing OrderNo. If existing, then I fill the fields up
saving them into TableB.
I would like to save the OrderID as well in TableB. How do I do it?
I can only save the OrderNo (pulled from TableA) into TableB.
TIA
M.

 

[Wayne Morgan]

Set the combo box to have 2 columns. Fill the combo box with a query that pulls the
OrderNo and OrderID from TableA. Sort on the OrderNo, if you wish, to have them show in
order in the drop down list. Set the Column Width property to zero for the OrderID column
(example if OrderID is in the first column: 0";1"). Set the Bound Column to the OrderID
column. This will store the OrderID, not the OrderNo, in TableB. You should only need to
store the unique one of the two of them.

The OrderID and OrderNo will be in the same order (left to right) as you have them in the
query used for the combo box's Row Source.