A visitor fills out the form Landing_Page and enters a Promo Code. On success I need to look up the entered Promo Code and match it to the promo code library form called Promo_Code. After a match I need the associated consultant from that promo code record (in the Promo_Code database) to be added to the record that the visitor just created when they completed the form.

Please advise how to do this