HiI have a requirement wherein a DCR field has to populated with multiple values. Basically these values has to be shown with the hihlighted mark based on the other field value. This field value is already avialable in the old dcrs. My query is how to make a server call efficiently to databse to satisfy the requirement. I am very much concerned about the performance issue on the server call. Comments on this requirement is much appreciated. If you guys have any bookmarked threads meeting such requirement also helps me a lot.
From what you've written - it sounds like you either need to use a cgi-callout or a FormAPI callServer script (since it's dependent on a value in another field - inline scripts don't seem to apply). The former is synchronous, the latter is asynchronous. Depending on how you code the script - it could be more or less efficient - but you will clearly have some overhead to deal with in initiating the process to initiate the query to the DB.I have no idea what you mean by values being shown with a highlighted mark though.
