Non-qualifier Auto Id

[Former Member]

Hello

we have a qulaified lookup table with all fields set as Qualified except one which is an AutoId field.

How do we handle the mapping of the qulaified lookup field in the the main table for the auto id seeing as we will not have a source field?

Do we need to map all the Qualified fields or just the qualified fields that are display field?

We keep getting the following error on import:

Import failed. Cannot import qualifiers because the qualified lookup field is not mapped.

Import action: Create

Source record no: 1

Kind Regards

C

[Former Member]

Hi Con,

Can you explain the scenario with an example..

That would make the question more clear..

Regards,

Tanveer.

[Former Member]

Hello

The senario is as follows:

Main table record Customer has a field of type qualifed lookup called Search key id. The qualified table is used to maintain a list of search keys per customer.

Lookup table is as follows:

Id AutoID Non-Qualifier

Key Text Qualifier

Status Text Qualifer.

We recieve on import:

Customer Number and map to Customer Number (main table)

Key Value and map to Key (qualified lookup table)

Status Value and map to Status (qualified lookup table)

We add a field "search Key" on import and map to search key (main table)

The question is how do we handle the AutoId field? E.g. If we import 3 search keys

for a customer autoid runs from 1 to 3 the qulaified lookup table

We keep getting an error when we try this. (see org. message)

Kind Regards

Con