How to make change to multiple related records?
Hey guys, here is my question:
1) I have created two related tables : Sheet(Parent) ,and Invoice(Child).
2) I have created field "project_s" in Table Sheet and "project_i" in Invoice.
3) A portal is set up to view all matched Invoice records in specific Sheet record;
Now let's say that for record 1 in Sheet there are 10 related records in Invoice.
4) When I give a project name in Sheet::project_s, I want to set it to Invoice::project_i for all 10 record related.
What should I do?
I am quite a starter for this.
Thanks a lot in advance for your help.