Page 1 of 1

auto value a field

Posted: 2013-12-03 12:45
by scorpio_x73
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.

Re: auto value a field

Posted: 2014-02-04 08:03
by a.gneady
I'm so sorry for the long delay. You should use the "filter by" option as explained in the cascading drop-downs tutorials here: http://bigprof.com/appgini/cascading-dropdowns