Hi Naomi.

>We have a table called Client_Product_Lines which has two fields among the other fields:
>cproduct_line_fk and cproduct_line
>
>Recently we wanted to remove one field from that table. Every time we run Update structure, the cProduct_Line field seems to take data from cProduct_Line_fk field.

See the answer to "When I used Update() to update my table structures, the contents of two fields in one table were swapped." in the Frequently Asked Questions topic in the help file (near the end of that topic).

Doug