Skip to Content
0
Former Member
Jun 03, 2008 at 03:05 PM

Can we run an assignment on a qualified table from a main table?

27 Views

Can I run an assignment on a qualified table from a main table.

For example: My main table Vendor and Qualified Table is Company Qualified .

Company Qualified - VendorNr (Non- Qualifier),Company(Qualifier,lookupFlat - Company)

Company - Name,Description (It has valid values in it already).

How to add a default value into the Company Qualified table.

When i add a assignment like

If(is_null(Company Qualified [Record],default lookup value from Company) ...it says invalid.

Any help greatly appreciated thanks