-Find isn't working

[Chirriras]

A quick overview: I have a project where 8 interviewers are conducting face to face surveys of about 10-12 Churches each. I have a database of 100 churches, detailing all the information about each church, including a unique identifying field and fields for comments.

I have another database of interviewers, with all the personal information on the interviewers, as well as fields for each interview including a unique identifier for the intrviewer--not the interview, date, status, and comments.

I have an opening page (findinterviewer.htm) where the project manager chooses from a list of interviewers the person whose record she wants to check. This takes her to Interviewer.htm where she sees the personal information on the interviewer as well as a list of the churches he/she is assigned to visit. The unique identifying number appears on this page when it opens.

On this page (Interviewer.htm), I have a button by each interview listed. What I WANT to happen is that when the button is clicked for Interview 5, for example, I will be directed to Interview05.htm, and the data for the interviewer and church will appear--this will be the detailed information on this particular interview.

I tried using the same method as for my earlier project, but I'm doing something wrong because I keep getting a message that no records are found when I know there ARE records to be found.

Below is the link I am attempting to use:

<a href="FMPro?-db=Interviewer.fp5&-format=Interview05.htm&IntvrID=[FMP-Field:IntvrID]&-find"><img src="interview5.gif" border="0" width="82" height="12"></a>

IntvrID is the unique interviewer ID. Where am I going wrong?

[Garry Claridge]

Are the "Interviews" in a related file to the "Interviewers"? If so, would this be the link:

href="FMPro?-db=Interviews.fp5&-format=Interview05.htm&IntvrID=[FMP-Field:IntvrID]&-find">

If not, are the "Interviews" in a repeating field? If so, you may need to perform a "-op=cn".

After you attempt the "-find" go to the database and perform a "Modify Last Find". This should tell you details of the attempt.

Try placing the link directly into the browser address bar to see what happens.

Good Luck.

Garry

[Steve T.]

churches db, interviewers db

findinterviewer.htm

* anna

* billy

* chelsea

* domingo

interviewer.htm (domingo)

* interview01

* interview05

* interview07

interview05.htm (intvrID)

Church of FM Enthusiasts, interviewed by Domingo

Hmm.. I would have thought you would have needed a 3rd db "interviews.fp5" that would have used data from each of the other two but I guess you could just put the churchID's ...

ah, jeez... I got to go... sorry. If I have time I'll try to finish up later if somone doesn't finish for me... really, really sorry! BTW... the intvrID is on the appropriate layout, right?

--ST

[Chirriras]

Actually I do have a 3rd db, Interviews.htm (you mindreader you), but can't seem to link everything together no matter what I do.

[Keith M. Davie]

My two cents worth. First, Gary is right. Perform the find and then check the db file to see what was entered, if anything, upon which the find is to operate. However, before you ever get to the find action for the interview there is something else you can do.

Your opening page, findinterviewer.htm, provides a list of interviewers. When an interviewer is selected that person's IntvrID should be carried to the results page (name not given, but lets call it interviewer.htm for this discussion). So before you even perform the find you would be advised to place (temporarily) [FMP-Field:IntvrID] on the top of "interviewer.htm" to make sure it is attached to that page.

From the link from "interviewer.htm" to a selected interview, what I fail to understand is why you would have a format file Interview05.htm. You should need only one results page (interview.htm) which would display the results regardless of the interviewer or the interview contents (number, source, whatever).

And if you must access a disparate database file, have you considered using an inlineaciton on the interview results page to do so?

Just incidentally, the link which you provide in your original post will find only the interviewer, if anything.

[Chirriras]

Let me try to clarify what I am trying to do. At this point I've confused myself to the level of minimal coherence!

I have 3 databases, that I have relationships assigned to, and I am trying to link them via web pages because the individual keeping track of the interview progress does not (and does not want) FMP.

My main page has links to all the projects. When the link to this project is clicked, the user must first provide a password to go any farther. The password determines WHAT records they can see. I do have the IntvrID come up on the Intrviewers.htm page.

Once the password is entered and accepted, they are directed to this project's menu page which provides links to: 1) the churches in Part I (different than the ones I'm trying to link to), 2)churches in Part A, 3)Interviewers, and 4) Interviews. Part I is irrelevant to what I am trying to accomplish here, so don't even consider it--it is a mail out questionnaire.

The project manager wants to be able to go to a web page (or series of web pages) to check the progress of interviewers and their assigned respondents. To accomplish this I have tried to (database names in parenthesis, page names in CAPS).

1)Provide a link on the menu page that will take the project manager to a "Search" page where she can choose the name of one interviewer, (Interviewers.fp5 IFIND.HTM), then

2) Be taken to a page that displays the interviewer's individual information as well as a list of the churches they have been assigned to (Interviewers.fp5 INTERVIEWER.HTM). Next,

3) Provide a link on each of those assigned churches that will take the PM to a page that displays all the information about the interview with that church, i.e., the status of the interview, the date it was scheduled, the date it was completed, the date the hard copy was submitted for data entry, any comments the interviewer had about the church or respondent (Interviews.fp5 INTERVIEW02.HTM).

I was able to get as far as getting into the Interviewer.htm where it showed the jobs assigned to that person, but in my confusion I accidentally deleted something I shouldn't have and now can't get anywhere!

When it was working, my next step was to have a link that would take me from a specific church listed on the Interviewers page to a page that would show all the info on that church/interview. I never did get that to work.

On each of the Interview##.htm pages, I have a button that is INTENDED to be able to jump to othr interviews. How could I jump from one interview to another without having separate pages and separate links.

I hope this better explains my intent. Right now I'm so confused I'm not even sure what day it is! I have one very bad habit--I tend to make things much more difficult than they really are. I always seem to go for the hard way to do things instead of the simple one. I have not totally confused myself. Thanks for trying to help.

[Garry Claridge]

Doesn't this:

<href="FMPro?-db=Interviewer.fp5&-format=Interview05.htm&IntvrID=[FMP-Field:IntvrID]&-find">

need to be changed to this:

<href="FMPro?-db=Interviews.fp5&-format=Interview05.htm&IntvrID=[FMP-Field:IntvrID]&-find">

Then to jump from interview-to-interview you can use some Javascript that increments the Format file number. Then assigns it to the appopriate Form element, e.g.:

<script>

jumptointerview()

{

document.myform.elements['-format'].value = "interview" + nextnumber + ".htm";

document.myform.submit();

}

</script>

Good Luck.

Garry

[Chirriras]

To eliminate some confusion, I changed the name of Interviews.fp5 to Assignments.fp5. The search page works fine, it takes me to the interviewer I want to see. Attached is a file that shows the webpage I set up, with the hope that you by seeing it you can tellunderstand what I want to do next.

I redid the databases, with Churches holding ONLY data specific to that church, the Interviewers holding ONLY data specific to that interviewer with nothing relating to the interview itself. Assignments contains all the data specific to the interview, with data pulled from both the Church and Interviewer databases.

On the first page shown in the attachment, how do I list all the churches assigned to that individual, then create a link to take you from the icon "Interview 1, Interview 2", etc. to a page that shows all the data specific to that interview (2nd page shown on attachment).

I have a unique identifying field for each church, each interviewer, and an auto-generated serial number for each assignment. The attached pdf file shows you how I'm trying to pull it together. I just can't seem to do it.

Thanks.

samples.pdf

[Garry Claridge]

Re: On the first page, how do I list all the churches assigned to that individual?

You can use a Portal or an [FMP-InlineAction].

Then include this:

[FMP-Portal: thechurches]

<a href="FMPro?-db=churches.fp5&-format=Interview[FMP-CurrentPortalRowNumber].htm&IntvrID=[FMP-Field:thechurches::IntvrID]&-find"><img src="interview[FMP-CurrentPortalRowNumber].gif" border="0" width="82" height="12"></a>

[/FMP-Portal]

All the best.

Garry

[Chirriras]

I'm sorry, but I'm just not getting this, I think I'm in way over my head. Remember, I am not a programmer, just a struggler. I'm probably making this way too difficult, something I always tend to do.

Can we start from scratch. I've made some changes to my databases because I realized I had major problems when I tried to run reports. Here's what I have now:

1) A database (ABChurch.fp5) which holds data on the churches involved: ChurchID (unique identifier),name, address, phone, denomination, contact name (up to 3), contact phone, contact email.

2) A database (Interviewer.fp5) which holds data only on the people conducting the interviews: IntvrID (unique identifier), name, address, phone, cell phone, email. I realized I was having problems running reports when I had 12 separate interviews listed in the Interviewer.fp5, so I eliminated that.

3) A database (Assignments.fp5) to hold information specific to the interviews, and contains information such as AssignmentID (auto-entered, unique identifier), date, status, and comments. Further, it pulls information from Interviewer.fp5 (Name and IntvrID), and from ABChurch.fp5 (ChurchID and ChurchName).

Here's what I need to do that I can't figure out and/or can't understand:

I want a single page to show the Interviewer's name and contact information, as well as a list of all the churches assigned to that interviewer.

Further, I would like to be able to make a link from each church on this page to the interview for that church. This way the project manager can see at a glance which churches are assigned to an interviewer, and then, with a click, go to any of the interviews to check it's status.

Is this impossible, or is this just another case of me making it too hard.