I am in the process of creating a database for use at the school that I teach at. The database is near to completion.

The problem I am having at this stage is displaying records found in a portal correctly.

The best way to describe the problem is to download the database (MASTER.fp7). It is compressed as a zip file.

The account name and password is

MASTER.fp7.zip

Your solution is locked. Without being able to look at your relationships and the script it will be impossible to tell why you are not getting the information you want.

Sorry. Try the new download. I've made sure you get full access to Accounts and Privileges. Login Accout and password are "abc".

Frank

MASTER.zip

This is classic behaviour I'm afraid.

You can't search portal like this. You'd better filter the portal with a global field filled with the criteria and branch a new table occurrence to the graph with this global matching the related infrigement.

Then , Go To Related records will just bring these records that mached your criterias.

See the small adjustments made to your file.

MASTER.zip

Thanks (from the land Down Under) for your quick response and solution. I'm very impressed!

Best wishes

Frank

Dear Ugo DI LUCA

Can I ask one final favour, please.

Executive staff will want to use the database to do the following:

-enter a single date e.g. 7.1.2005 or a date range 1.1.2005..7.1.2005 to check for all students in the school from Years 7-12 (e.g. Who in the school ended up on the database today or between <date1> and <date2>) and show

- name of each found student

- Year (Group) that each found student belongs to (7,8,9,10,11,12)

- homeclass of each student (A,B,C,D,E,F)

- infringements committed by each found student

OR they will want to use the database to

- enter a single date e.g. 7.1.2005 or a date range 1.1.2005..7.1.2005 and a specific Year Group (e.g. Who in Year 9 ended up on the database today or between <date1> and <date2>) to display:

-name of each found student

-Year Group (even though it will be the same for all students found but that is OK)

-Homeclass of each student (A,B,C,D,E,F)

-infringement committed by each found student

Can this be done?

Frank

It can for sure.

This is just how filtering portals work.

The only issue here is your "OR", that is either a Range or a Fixed value (date or School Year).

You can work with ranges just using in this case a 4 joined keys

g_StartingDate>=Date

g_EndingDate<=Date

You can even keep this unique relationship for a search on either a range or a fixed date.You would need to script the process so that when only one of the 2 keys is filled, the same value would be entered into the second key.

Mixing the 4 keys alltogether would give you a relationship to a new occurrence of the Student Table.

g_StartingDate>=Date

g_EndingDate<=Date

g_StartingGroupYear>=GroupYear

g_EndingGroupYear<=GroupYear

Then displaying the data you want is just a matter of how the Student Table relates to the others, as all data isn't stored in this same Table.

Thanks Ugo for your reply - much appreciated

As a newbie, however, your response is beyond my level of inderstanding of this level of FMP7. Is there any way of giving a "dummies guide" to your previous reply? I feel I am getting very close to what I want the database to achieve!

Framk

I have zero experience with Schools and the like except some small stuff, but looking back to your file, I would guess you'd need to start taking advantage of the Relational Model.

Then, how you'd grab data from either a classic search or a filtered portal will become more easy.

Here's attached a small adapatation of your graph, as I would do it.