Values not showing
I have three tables, T1(Field A), T2(Field A and Field B) and T3(Field A, Field B and Field C). I created two value lists List B and List C. List B includes all values of Field B from T2. List C includes only values related to Field B starting from T2.
On one layout, I have Field B and Fielld C. List B is the drop list for Field B. List C is the drop list for Field C. Once a value is picked up from List B, only related values will show up on the drop list for Field C.
The problem is nothing is showing up in Field C.
Hope I made it clear.
Please help. Thank you!