Self-relationship problem...

[dimension]

Hi - this is my first post, hope someone can help(!)

...Here's my problem;

I have an table linked to & . I need to display a portal showing a 'see also' reference(of the *same* table).

So, for example, an asset named

will bring up records in the portal such as

, , ect.

Thanks in advanced!

[Razumovsky]

Welcome Dimension,

It is difficult to help without knowing more details like:

How are your files related?

What table are you trying to see also from?

What do you mean by 'see also'? Do you want to see all of the other records in that table (use a does not equal relationship) or a subset? In which case, how do you define the subsets?

[dimension]

Hi Razumovsky, thanks for the reply.

What I am trying to do is view in a portal, from the same table and on the same form, items that are in the same class.

All my tables have a unique key (random*random), the assets table has field . So viewing a record in would display all the related records in a portal (on the same form).

Does this clarify things a little?

Thanks!

[Razumovsky]

Slightly...

Seems like you would just need a relationship to the same table where:

Class=Class and

UniqueID ≠ UniqueID

Put a portal based on this relationship on the layout, voila!

All my tables have a unique key (random*random)

Completely random keys are not assured of producing unique results (if it happened by chance once, it can happen by chance again). I would stick with a simple serial number.

Cheers,

-Raz

[dimension]

Hi Razumovsky! Solved the problem - many thanks for your advice!!

Your tip has saved me many (more!) wasted hours

My form now shows correctly, via a portal, all the records of a related class, except the current record.

Clicking on a record in the portal displays the record via the duplicated (self-join) assets form.

Thanks again!