Setting a field in related table through portal?
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.