How to give a table view clickable functionality

[AndyBannister]

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

[Razumovsky]

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

[Raybaudi]

"You cannot put buttons on table view."

Sure ?

[AndyBannister]

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

Edited June 21, 2006 by Guest

[Razumovsky]

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

[Raybaudi]

"I believe you can put buttons on the header and footer around a table view"

...to this type of buttons I was referring !

BTW: another strange effect comes today...I'm any more able to "QUOTE" a post

[Razumovsky]

BTW: another strange effect comes today...I'm any more able to "QUOTE" a post

I was never really much of a Mac snob, but can't help feeling a tiny bit smug now...

[Raybaudi]

I don't think that it's a Windows issue... yesterday worked !

So now more problems with owners of IE and this site ! :P

[Razumovsky]

I don't think that it's a Windows issue...

Well, I guess it is a windows + IE issue, as this was done with mac+IE. Poor Stephen! you should let him know in the feedback section...

-Raz