AnsweredAssumed Answered

Setting a field in related table through portal?

Question asked by SimonSherwood_1 on Oct 1, 2013
Latest reply on Oct 1, 2013 by 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.

Outcomes