show current record relation

[vierdewereld]

Sure wish there was a calculation function that would give ;1 when that record is active (currently displayed).

Even better if this can be done unstored.

This way it would be possible to create a relation from another file to (only) that active record.

I would just need to have 1 record in the other file to display the same info of the file with all the records in it.

Perhaps somebody has figured this one out.

I tried it with a Selfjoin relationship but this makes the calculation unstored and a relationship only works with Indexed calculation.

Or is there a neet trick with the look-up.

Can't understand that there is no Get (ActiveRecord) function. :

Any thought is welcome...

[comment]

This is impossible by definition. What are you trying to achieve? Surely there's another way.

[vierdewereld]

The other way...

Just added every navigational, find, delete / new record, etc script with a set field that places the UniqueID to the Global field of the other file.

Making it possible to create a relationship to the file with all the records and have it synchronized.

Guess there is no other way to do this then, without having to duplicate all the records.

[comment]

I still don't know what you're trying to achieve.

[vierdewereld]

Display the current selected record in a different file (Window)...

preferred automatic

Selecting the relationship in the Layout Setup doesn't do the trick.

[comment]

I'll try this once again:

I am asking about your purpose. "Display the current selected record in a different file (Window)" doesn't mean anything to me. I suppose you feel that you need this in order to achieve something. I am asking what is that something.

[vierdewereld]

What I try to achieve is to have a navigational window floating above the main window of the database.

In this navigation window you always see the current record of the main database

(file).

The problem I encountered now is that get (recordnumber) function doesn't work in a different window. Even with a relationship it will always display the current record number of that window and not the current record of the main database.

This means I can't get my navigation indicator to work in the navigation window (file).

Any suggestions?

[comment]

I see now. I don't think there is a way other than setting a global with the current record's serial ID. Your navigation window is another file. Your main file could be opened by two users at the same time. Which user's active record would be the correct one, from the POV of the navigation file?

[vierdewereld]

Didn't think about that...

Good thing my app is not going to be distributed on a network.

Thanks for all your [color:orange]Comments :