Need help with relationshops in attached file

[fbugeja]

I am a schoolteacher creating a database for school use. I am still in the learning stage of using FM to create applications.

Here is my situation. I have created a database called MASTER.( It includes different levels of access. What I am trying to achieve in one part of the database is for a form letter to be filled in with details which come from another part of the database.

To explain my situation, do the following

1. Open MASTER.fp7 using

MASTER.ZIP

[Fenton]

Well, you've got a relationship between a calculation field, Student & global layout, matching a StudentMatch field in the Infringements table. But:

1. You're going to the layout with the button, but you have no mechanism to create the new record (letter) in Infringements. Nor pass the data for the key, which would be the student.

2. I don't see what the global layout is doing in the key. It's use stops indexing of the key, thus destroys the 2-way nature of the relationship, which would otherwise just be the student, and be indexed.

3. The merge fields on the letter itself would be related fields, reaching back to the student. Ruined by above.

4. Your date fields are type Text.

5. If all you're using Infringements for is to send letters for Zero Awards, then you don't really need it as a separate table. It could just be a layout of Zero Awards. It would then be a lot easier to see if a letter had been sent. But maybe you have other plans for it; or send more than one letter for a Zero Award?

[fbugeja]

Dear Fenton,

Me again. I got the program I uploaded from another teacher at another school. I have been looking at his scripts, layouts, and trying to learn what he has done to suit my school's needs.

If you could modify the program and send it to me, I will be greatful. I am on a learning curve! (Another beer I owe you when you come to Sydney).

Frank