You’re offline. This is a read only version of the page.
Hi - hoping someone can help me! I've searched and searched but haven't been able to find a solution that works yet!
I have a table: 'AU RA Details'
This table contains a lookup column to another table called 'Product Masters' (so that users can select a product code on various forms/dropdowns etc)
I have a gallery (GalInvLines) that has data from another table: 'AU invoice lines' I want to patch into 'AU RA Details'. This might be one line, or could be 50 lines with different product codes. The codes will all match exactly.
I've tried lots of various things - the closest it's come to working is this:
However, this is patching either a blank value or if an item in the gallery has been selected, the same value for each record....... How can i get the product code from each line of GalInvLines into 'AU RA Details'. All other information is copying correctly, just the SKU code isn't!!!
Thanks for any help!
Rowan
Two questions:
1) Why are you referring the control with @, why not the control name directly?
2) Have you investigated what LookUp('product masters',PMPART=LblSKUCode.Text) returns?
Hi Sudeep
Yes - I want to patch the value from lblSKUCode into the column in 'AU RA Details' for the SKU Code. But this column is a lookup column and I can't get it to just accept the label value.
LookUp() function will return a record.
Wouldn't you specify which specific field (from the record) you want to store in SKU?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
Share
Report
All responses (
Answers (
14,123
