Insert Into Function with a Lookup Field
Hi -
I am trying to create a new record in Form B when someone adds new information to Form A. However, one of the fields in Form B is a look-up field from Form A. Specifically, Form B has a customer look-up from Form A...when I update some customer info on Form A I want to use the "insert into" script to post a record to Form B, including the customer name
I know how to do a collection variable to pull data from another form, but this seems the reverse since I am writing to another form that is doing the look-up.
Does anyone have some sample code they could share?
Thanks