Page 1 of 1
Custom Property Sets - Data from other databases
Posted: Sat Aug 08, 2009 6:54 pm
by Data
I would like to create a drop down field to present the user with a list of options. In my case the options are not static. Can I retrieve them from a DB other than the inforouter database every time a user is presented with the options?
Re: Custom Property Sets - Data from other databases
Posted: Mon Sep 07, 2009 2:59 am
by infoRouter Guru
Easy!
All you have to do is create a field in a custom property. Be sure to create the type as "lookup".
Click on the field properties icon to specify the Database/Table/SQL settings.
Remember to be careful when you create the SQL statement. As my good friend Ray Petrone says:
The problem is always in the where clause
- Lookup.jpg (129.25 KiB) Viewed 26601 times
Hope this helps.
The Guru.
Re: Custom Property Sets - Data from other databases
Posted: Thu Aug 12, 2010 9:09 am
by tengiz
hello
can i use in sql statment value of other lookup field?
exampl:
AAA field type lookup
BBB field type lookup and SQL is { Select Name from Company where CompId= AAA field value }
Re: Custom Property Sets - Data from other databases
Posted: Fri Sep 03, 2010 4:20 am
by infoRouter Guru
As far as I know, it should work. Just get the where clause to work.
Re: Custom Property Sets - Data from other databases
Posted: Tue Sep 07, 2010 3:44 am
by tengiz
hello,
can you give me some example?