Hi everyone,
Again I'm trying to do something that is probably out of the ordinary. What I'm trying to do is on the Sales Order Entry - Lines tab, there are the Customer Part and rev textboxes. I would like to be able to put different values in. However, it seems that not only are the xpartnum and xrevisionnum fields in the orderdtl table, but it's somehow tied to the custxprt table. If I want to use the same customer part, but a different rev, when I try to save, it feels the need to pull the old rev from the custxprt table and stick it in the orderdtl table. I've tried a slew of different ways to defeat this, but I just can't. I tried to unlink the textboxes from the table and use code to populate the orderdtl table, but that didn't work. Does anyone know a way to get around having the custxprt weasel it's way in to the orderdtl table? I know it probably does it for a reason, but we want to change that if possible.
Thanks for any help!!!
Regards,
Kurt
Again I'm trying to do something that is probably out of the ordinary. What I'm trying to do is on the Sales Order Entry - Lines tab, there are the Customer Part and rev textboxes. I would like to be able to put different values in. However, it seems that not only are the xpartnum and xrevisionnum fields in the orderdtl table, but it's somehow tied to the custxprt table. If I want to use the same customer part, but a different rev, when I try to save, it feels the need to pull the old rev from the custxprt table and stick it in the orderdtl table. I've tried a slew of different ways to defeat this, but I just can't. I tried to unlink the textboxes from the table and use code to populate the orderdtl table, but that didn't work. Does anyone know a way to get around having the custxprt weasel it's way in to the orderdtl table? I know it probably does it for a reason, but we want to change that if possible.
Thanks for any help!!!
Regards,
Kurt