I had made combo box in a view using HTML in column formula.But i need to populate its text and values from documents in another database.
How to do it !!!
PLz help!!
Subject: populating Combobox
You could put the values on a profile document that is filled in when the view opens. I think @GetProfileField is OK for column values (I am running an agent right now so I can’t check the help file to verify this).
Subject: populating Combobox
use dblookup to receive these values. and then put to it to combobox
Subject: RE: populating Combobox
DBlookup can not be run in column formulaenc, how to achieve it??
Subject: RE: populating Combobox
There is no way to use @DbLookup or @DbColumn or @GetProfileField in a column formula. I believe you would have either to store the list of choices in the document, or else have JavaScript code to populate the choice lists in the onload event of the page. Of course the JavaScript code would have to have the data to do this, which you could get with passthru HTML generated by a formula and containing @DbColumn or whatever. In other words, you would have to write a formula that contains the JavaScript code that initializes a structure containing the lookup data. This will not work if you need to use data from the documents as lookup keys, as you would need to load the whole view you’re looking up into, which could be slow. There are other ways using an applet that communicates with the server, which are a bit of work.
Is it an option to use NSFDB2? That give you more choices.