relational database problems

[ThatDeadDude]

I am trying to create a solution for a recruitment company. I've set up separate databases for recruiter details, and candidate details. Each candidate, and each recruiter is assigned a serial number as a reference ID.

No problems there.

Now, what I've been asked to do is have it so that you can go to the record for a specific recruiter, and see all the candidates who are related in whatever way to that, and vice versa. After trawling through the FM5 help files, I eventually got a many-to-many relationship up and running using the reference IDs as the base relationships.

What I'm trying to do now, however, is get it so that, say, you click on a specific candidate's details in the portal in the recruiter's database, and it will then take you to the client database, setting the current record to be the one you just clicked. I've worked out how to do this using copy[] and paste[], but I'd rather have a method that wouldn't overwrite anything on the clipboard.

Any ideas?

[sbg2]

Try the Go To Related Record script step

[jonathanstark]

.

[ThatDeadDude]

Doesn't really work. The way the help file got me setting it up, it just takes me to the intermediary file, as apposed to the one I want, which is the actual candidate record.

Okay, wait, you're right. If I call a similar event in the intermediary file, it all works out.

Thanks.

Edited August 3, 2005 by Guest
I was stupid