Hi All -
I have a dillema and I just can't figure it out. I am trying to help a customer with their database. They need to update a large amount of data and I was trying to create an update query for them.
The designer of the db, who no longer works at the company, created lookup fields within the table. The fields are bound to the actual text description and that is what you see while the stored data is a number and the field is type number. When I tried to update the table, and use the actual stored number it overwrote the text descriptions. When I tried to use the text descriptions, I received a mismatch in the update and none of the records were updated.
Is there a workaround for this or something I can do to get the table updated?
For example the headers Category, Vendor and Manufacturer are lookup fields within the table. When I select the dropdown for Vendor there are two columns of data in the dropdown, the ID and the desc. I select ID# 1 and Descr Terminals. The field then reads Terminals. But when I look at the design of the field it is a number field and the update query will only accept numbers. So I update using IDs and the field that read terminals shows 1 now. How do I fix it where it will accept text or use the number to pull in the right description?
I don't have the database b/c the customer will not let us have their data. I have to work on this remotely.
Thank you for your help!!!!
I have a dillema and I just can't figure it out. I am trying to help a customer with their database. They need to update a large amount of data and I was trying to create an update query for them.
The designer of the db, who no longer works at the company, created lookup fields within the table. The fields are bound to the actual text description and that is what you see while the stored data is a number and the field is type number. When I tried to update the table, and use the actual stored number it overwrote the text descriptions. When I tried to use the text descriptions, I received a mismatch in the update and none of the records were updated.
Is there a workaround for this or something I can do to get the table updated?
For example the headers Category, Vendor and Manufacturer are lookup fields within the table. When I select the dropdown for Vendor there are two columns of data in the dropdown, the ID and the desc. I select ID# 1 and Descr Terminals. The field then reads Terminals. But when I look at the design of the field it is a number field and the update query will only accept numbers. So I update using IDs and the field that read terminals shows 1 now. How do I fix it where it will accept text or use the number to pull in the right description?
I don't have the database b/c the customer will not let us have their data. I have to work on this remotely.
Thank you for your help!!!!
