Vlookup to other vlookup having 2 caption fields

[jbielak]

Hi,

This is my first post, so I'd like to welcome everyone

AppGini 22.11

I have the following scenario with 3 tables:

• po_items

• sites_orders

• serial_numbers

Field sites_orders->po_number is vlookup and takes caption 1 and caption 2 from:

• po_items->item

• po_items->po_number

with separator ": "

Field serial_numbers->po_number is vlookup and takes caption 1 from:

• sites_orders->po_number

When inserting a new record in table "serial_numbers", the dropdown for "po_number" displays properly "item: po_number" (separator is present). Once inserted, the separator is gone and the value is displayed as one string composed from caption 1 and caption 2 mentioned above.

new record: item: po_number
inserted: itempo_number

Is this a normal behavior?
If yes, how to make serial_numbers->po_number shown with separator, as in the original table?