in Table A and B have both company and address fields.
From B table, using lookup table, I can call company of Table A and display it in company of table B
and I want it also automatically fill the address of table B from the address of Table A as well, how do I do that?
I think I have to put something in Server Events but I don't know the code to do that and hoping someone does, thanks.
using Lookup table to display 2 fields
-
- User
- Posts: 17
using Lookup table to display 2 fields
-
- User
- Posts: 11660
You may simply enable "Auto fill" property from "Lookup Table" pane under "Fields" setup.
Please read "Lookup Table" topic from PHPMaker Help menu, and see "Auto fill" option under that topic. For the real example, you may refer to the demo project, see "orderdetails" table -> "ProductID" field.