Custom Property Sets - Data from other databases
Moderator: infoRouter Guru
Custom Property Sets - Data from other databases
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?
- infoRouter Guru
- Posts: 230
- Joined: Fri Aug 07, 2009 8:46 pm
Re: Custom Property Sets - Data from other databases
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 Guru.
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:
Hope this helps.The problem is always in the where clause
The Guru.
Re: Custom Property Sets - Data from other databases
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 }
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 }
- infoRouter Guru
- Posts: 230
- Joined: Fri Aug 07, 2009 8:46 pm
Re: Custom Property Sets - Data from other databases
As far as I know, it should work. Just get the where clause to work.
Re: Custom Property Sets - Data from other databases
hello,
can you give me some example?
can you give me some example?
Return to “General Questions & Issues About infoRouter EDMS”
Who is online
Users browsing this forum: No registered users and 9 guests