You’re offline. This is a read only version of the page.
12
Hi All,
I have 3 tables. Category(typeid), item (itemid) & deployed items (lockeritemid)- which are using itemid then lookup to get the full item name.
I forgot to copy over the category ids to deployed items, where i need it. the items tables, have the typeid assigned.
Can i make a button/code to correct this mistake such as: where deployed forall itemid = itemid in item table, copy typeid to deployed items table typeid field?
or can you do a 3 table lookup, itemid = itemid, then that itemid whats the typeid on that record ?
Total of 1000 items to patch
Hope this makes sense,
Thank you guru's !
Hi all, patched it over and it worked. although its done a lookup on the type table, instead of just copying over the "id"
What did I do wrong
Share
Report
All responses (
Answers (
