Calculated relationship

[Ben Ball]

I have two tables. Table A and Table B.

Table B shows through a portal in table A.

The condition is: Link: Number to Number.

In table B i wish to view all records greater than that shown in table A .

NO problem... I can do this

Is it possible to make a calculation field to show Values ony within say 50 of the number in table A from table B? If so does anyone know the calculation?

[Søren Dyhr]

Do you mean exactly 50 related record or just within the range 50 above the value in TableA??? It looks like the later, and if it is then make an unstored calc'field = TableA::Number+50 and then make a less than equal relation more from the new one and again aim for TableB::Number...

--sd

[Ben Ball]

Yes SØren... perfect thankyou...

I added the calculation as you said with the relationship laid out as shown below.

[Søren Dyhr]

Yes - But by the look of it do you have indexing turned on the calc'field which not is needed, the difference is that the unstored calc' only evaluates when the specific record is rendered on the layout.

This "just in time" approach, makes the consumtion of storage space less of an issue.

However should the calc'field be stored if you solution uses GTRR(FS) ...that is one of ways of using the bidirectionality the relations implementation this tool exhibits if you wish to use it.

--sd