Create a lookup of Form Objects

rikku

Hi,

I need to create a lookup of Form Objects in the field of a Table.
ie in the lookup the list of all Form names and IDs should display.
Please help me ...

Thanks in advance ...

mohana_cse06

rikku wrote:

Hi,

I need to create a lookup of Form Objects in the field of a Table.
ie in the lookup the list of all Form names and IDs should display.
Please help me ...

Thanks in advance ...

check permissions table for help

kine

Create new form with info you want and open this form through OnLookup code. You cannot set the Lookup Form ID property on the object table...

rikku

kine wrote:

Create new form with info you want and open this form through OnLookup code. You cannot set the Lookup Form ID property on the object table...

Which table i need to refer in the lookup form

kine

Hmmm... I do not know... what about table "Object"? :whistle:

garak

rikku wrote:

Hi,

I need to create a lookup of Form Objects in the field of a Table.
ie in the lookup the list of all Form names and IDs should display.
Please help me ...

Thanks in advance ...

Which table i need to refer in the lookup form

You need a form with ID/Name/Caption of all forms in your database?
If yes, take a look to form 358 Objects. you can run this form from OnLookup Trigger of your field or if you really need the Form ID in your Field in your Table you can set the table relation to "AllObj."Object ID" WHERE (Object Type=FIELD(Form))". <- So you doesn't need any source in the OnLookup()

Regards