Shawn Pelletier 28.Jan.13 02:08 PM a Web browser Applications Development 6.5.4 Windows XP
I need some direction on the best route to take. I'm trying to grab data from a certain view by using a key. I've used DbLookup before but I don't believe I can use it on a querysave event. I've never used GetDocumentByKey before. Here is what I need.......
Order Form Fields:
Vendor1: The field where the final result needs to be
Heci: The field used for the initial key
Heci: The field/column that has data that needs to match up with the Heci form field
HeciVendor: The field/column that has data that will populate the Vendor1 form field in the end
So...if Part#xyz is in the Heci form field it will look up that part# in the Heci column in the PartsByVendor view and find the Vendor asscociated with that part number and return it to the Vendor1 form field.
So...I'm not sure where to go with this, any suggestions would be appreciated. This is going to be used before the form closes as the Key field won't be populated until further down the form, not on form load. Thanks a bunch!