Data Linking

[Ljffusion1]

Ok I have 2 Tables

One is called Production the other is called Operations.

I made a form for the Production table with 2 Combo Boxes

The first combo box is OperationID and The Second is OperationName

What I need to do is have it so that when I select the OperationID
which would be 10, I need the OperationName to automaticly appear in
the OperationName box. Both values are drawn from the operations table
and will be stored in the production table in identical fields

Thanks

 

[Arvin Meyer [MVP]]

If the OperationName is store in the Operations table, you only need to
store it once, not in both tables. It would be better to store only the
OperationID in the Production table. You can easily view the OperationName
in the combo, instead of the OperationID, by setting the column width
property of OperationID to 0 (zero) and allowing sufficient width to view
the OperationName.