How to give a table view clickable functionality

June 21, 200619 yr

Newbies

Hi, hope this is the right place to post this question, as it sort of straddles a form/portal divide.

What I am trying to do is add a "Find Duplicates" function to a major contacts database for the university I work for. Idea is that:

(1) Find Duplicates button on the main Contacts form pops open a dialog box.

(2) The dialog allows the user to choose which field (Surname, Organisation) to check for duplicates and what other information to factor in when considering a record a duplicate.

(3) On clicking OK, a table style view of every matching record opens in a new window.

(4) User can click on any one of these table rows to open the full record card back in the main Contacts form.

Now I've got steps (1) thru (3) working beautifully. Trouble is, to do (3), I need to use a form in table view and this does not allow a script to fire when a record is clicked, thus getting me to (4). I considered using a portal instead for (3), but can't find a way to run a find-duplicates query (with the ! operator) on portal rows.

Any suggestions or advice would be gratefully received. And, if as is perfectly possible, I have not been clear enough in explaining what I am trying to do, I can elaborate!

Many thanks.

Andy

June 21, 200619 yr

Welcome Andy,

Use 2 layouts, one in form view and one in list view in which you would arrange your fields just like they would be in table view. Place a button on the list layout to have it go to layout (form). You cannot put buttons on table view.

HTH

-Raz

June 21, 200619 yr

"You cannot put buttons on table view."

Sure ?

June 21, 200619 yr

Author
Newbies

Thanks for the reply; I'll give that a go ...

Edited June 21, 200619 yr by Guest

June 21, 200619 yr

I believe you can put buttons on the header and footer around a table view, but not on the table view records themselves.

But no, I am not sure. I just have never seen it done or found it documented. I actually have never used table view for the user side of my solutions, only for quickly viewing data while developing.

-Raz