[Q] Converting table

[Kevin Labore]

Hi

Can someone tell me how to convert a table?

The table was originally set up for the original POS data
The new format of the POS data doesnt have the DeptNum but instead the
DeptDesc

In any event the table(DeptSalesDetail) that currently contains a field for
Deptnum
table(Depts) contains Fields (DeptID, Deptnum, DeptDesc, CatID...)

What I would like to do is to add the field DeptID and eliminate the DeptNum
from the table(DeptSalesDetail)
How do I get the correct DeptID from the table(depts) to get in to the
DeptID in the table( DeptSalesDetail)
This way I can have a lookup from the DeptDesc from the POS Data and plug in
the correct DeptID
Data currently already exists in all tables.

Hopefully this is short and clear enough.
Thanks for any help

Kevin

 

[Arvin Meyer [MVP]]

You need a matching field in both tables. Add the new field to the detail
table, and use an update query to fill it from the Depts table. If you don't
have a matching field to join on, you cannot update the details table.

 

[Kevin Labore]

Hi Arvin

Thanks for the help, I thought that an update was the way to go.
I have only used one once before.
I will have to look at an example so I make sure I update the table
correctly.

Thanks
Kevin