This content has been marked as final. Show 2 replies
Important is first that you include the FK relation in the table design of table A. Forms generator uses this FK relation to identify the block items involved.
Then you base your block on table A, and create a lookup table usage for table B by right clicking on Table Usage of A. If you properly defined your FK in the table design, you will see table B.
Include the display value of table B as a bound item.
Attach the LOV to the lookoup item in the lookup table B. Forms generator will automatically return the values in the proper items (id in table A and lookup in the display item of table B).
For more info, see many topics about lookup items and LOV's in the Help.