auto value a field
Posted: 2013-12-03 12:45
Thanks in advance for any help.
Scenario:
I have 3 tables
Table 1 : Contacts
Table 2 : Calls
Table 3 : unfinished_jobs
"Table2 - calls" gets the client details from "Table1 - contacts" and "Table3 - unfinished_jobs" gets the contact details from "Table2 - calls"
So far all are working fine.
I now have "Table2 - calls" as tab in the contacts screen, but i want also the "Table3 - unfinished_jobs" to be visible in the contacts page.
So i created a second field in "Table3 - unfinished_jobs" to get the value from "Table1 - contacts" and it works ok.
Ok so far..
The problem is that i have to choose 2 times the client (first is auto fill from "Table2 - calls") and the second for the table "Table1 - contacts".
Any way to assign the value from a field from "Table2 - calls" to "Table1 - contacts" ?
Thank you again for any info.
Scenario:
I have 3 tables
Table 1 : Contacts
Table 2 : Calls
Table 3 : unfinished_jobs
"Table2 - calls" gets the client details from "Table1 - contacts" and "Table3 - unfinished_jobs" gets the contact details from "Table2 - calls"
So far all are working fine.
I now have "Table2 - calls" as tab in the contacts screen, but i want also the "Table3 - unfinished_jobs" to be visible in the contacts page.
So i created a second field in "Table3 - unfinished_jobs" to get the value from "Table1 - contacts" and it works ok.
Ok so far..
The problem is that i have to choose 2 times the client (first is auto fill from "Table2 - calls") and the second for the table "Table1 - contacts".
Any way to assign the value from a field from "Table2 - calls" to "Table1 - contacts" ?
Thank you again for any info.