Hi all,

In my university database, I have a portal which includes the fields of subject, year subject offered, not offered etc.

Problem 1

I want to create a layout (letter) where I can selectively choose particular subjects to appear in the letter. Currently ALL the subjects appear (or as many rows as the portal has), which is not what I want. I want to selectively choose subject 3 and subject 5 for instance, to appear in the letter and no other.

How do I do this?

Problem 2

There is also a script set up as a button which database users can press to email individual students if a subject becomes available.

Again, how can I selectively choose in the script particular subjects and not others, so only subjects 3 and 5 for instance, will appear in the email.

Please note that all this to date has been setup for me...so please 'simple' language in your explanation is much appreciated.

Thanks.

Edited April 2, 200916 yr by Guest

You can store the record IDs of the records you choose into a global text field. (multi-line) Then you can use Go to related record or use another table occurrence from the global field to the child table with a List () calc.

Thanks John, but I did say simple language.

Any chance you could elaborate on what you mean?

Thanks.

Anyone?

Please.

It seems to me that you are using a FM database and do not have developer level access? Do you? Can you select Manage Database from the File menu?

If not, you cannot add the features that you are requesting.

Yes I do have developer access..

..the problem is that I don't know how to resolve the problems stated above. I have access to do it but just don't know how.

Any ideas?

Thanks.