Lookup table problem (v2019)

PHPMaker General Discussion (PHPMaker)
1

I am using PHPMaker 2019, and I want to ask something about lookup table
Is it possible to display fields “c_field_1” in table view of “Table_A” with “lookup table”?
I can only display “b_field_1”, but not “c_field_1”
Thanks

Table_A

  • a_pk
  • a_field_1
  • a_field_2
  • b_pk

Table_B

  • b_pk
  • b_field_1
  • c_pk

Table_C

  • c_pk
  • c_field_1
2

You may create a view to join table B and C first, then use the view as lookup table.

3

arbei wrote:

You may create a view to join table B and C first, then use the view as
lookup table.

Thanks for your info.