1 Reply Latest reply on Oct 1, 2013 6:36 AM by SimonSherwood_1

    Setting a field in related table through portal?

    SimonSherwood_1

      Title

      Setting a field in related table through portal?

      Post

           Hi guys

           I've got 2 related tables customers and transactions.  They are related by a serial number ID field, I had also related them by an address field as well but decided to remove the relationship as if I made a correction to the address field it would unrelate the relationship.

           Basically I enter data into the transactions table via a portal on the customer's table form.  What I want to do is automatically copy the address from the in an address field in the customer table to the related record address field every time I fill out a new portal record in the customer form.

           Hope this makes sense.  I've experimented with scripting to do this but as yet have no success.

            

           Simon.