- "Writer": The writer assigned to the client. This is a Lookup field that is linked to the Writers form.
- "Total Words": How many words are written per month is entered in this field.
- "Monthly Cost": The monthly cost of the writer assigned to the client, calculated by the writer's Rate Per Word multiplied by Total Words.
The Monthly Cost field needs to be calculated by the relevant Rate Per Word field listed within the Writers form multiplied by the relevant Total Words field contained within the Clients form. How do I do this?