Displaying found records from a portal correctly

[fbugeja]

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

[Walter B]

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.

[fbugeja]

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

[Ugo DI LUCA]

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.

[Ugo DI LUCA]

See the small adjustments made to your file.

MASTER.zip

[fbugeja]

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

Best wishes

Frank

[fbugeja]

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

[Ugo DI LUCA]

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.

[fbugeja]

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

[Ugo DI LUCA]

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.