Multi Table lookup fields

(0) Share

Report

Posted on by Abdullah_Ahmed

I have a form with 2 datasources QuotationTable and QuotationLine.. QuotationLine has a field called ItemId related to InventTable. I want to override the lookup for ItemId

so, I tried to override lookup method of itemId field in QuotationLine but it gave me the error that 2 lookup forms trying to open! So I override the event handler of ItemNumber control in the grid.

- the sysTableLookup has QuotationLine as a parameter but it isn't used as qbds below.

- I tried to have Quotation line as qbds and then link qbdsInventTable with it and I get the error: "Attempted to read or write protected memory. This is often an indication that other memory is corrupt"

- the error I get: 'Failed to execute query because no root data source on the form matches the root datasource on the query.'

Categories:

Financial Management

Integrations

All responses (1)

Answers (0)

Layan Jwei 4,728 Super User on at

Like (0)

Report

Multi Table lookup fields

Hi,

SysTableLookup doesn't support adding fields from multiple tables.

You could create a View with all of those joins and use it with sysTableLookup

Thanks,

Layan Jweihan

Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future