Create Custom LOV

Hi,

I would like to create a custom LOV file. I created a tab delimited text file for the same. I created an object in the unvierse and pointed the LOV to this file.

After this what should I do. Should the object point to some field in any table of my database? Basically, when I deleted the field and just made an association for a table, it gives me a DB error in Full client. When I remove the table association, it gives me an error which says “The query doesnt reference a table”.

When i associate a field for the object, the values come from DB rather than LOV.

Can someone brief me on the procedures for the same?

Imagine I have a text file which is tab delimited with multiple fields. How do I create LOV for a specific field in the file?

I searched a lot in the posts and did n’t find answer for this. Please help me out

Thanks & Regards
Venkatesh V.


v_venkie (BOB member since 2004-06-09)

Create your object pointing to the column in the database, not your text file. Make sure you set the LOV to export with the universe. Then, go to Tools - Lists of Values. Find your object, then, down below, choose personal data. This will walk you through setting up the LOV based on your text file.


MichaelWelter :vatican_city: (BOB member since 2002-08-08)