Auto Id as Non-Qualifer

[Former Member]

Hi Guys

I already open a thread on this topic but maybe I was not so clear on the issue.

Can some please tell us how we can use a Auto Id filed as the Non-Qualifier field in a Qualified lookup table?

All other fields in the same lookup table we want as Qualifiers.

How do we map to the Non-Qualifer, Auto Id field on import seeing as we will not have a corresponding value in the source data

All help is greatly appricated

Rgs

C

[Former Member · Accepted solution]

You create a new table of type FLAT.

Create two fields for this table.

One of them is a AutoId type field. Make this the display field. Another field could be description field or something like that.

Create a Qualified table. Make the non-qualifier field as type look up to the Flat table you created above.

Add all the qualifers you need.

This way you can look up the autoids of the lookup table as NON Qualifiers.

Hope this helps.

[Former Member · Accepted solution]

Thank you Michael

[Former Member · Accepted solution]

Thank you Michael