how to create a self-join 
Author Message
 how to create a self-join
I have a flat database of business contacts. Below is some sample
data:

ID, Name, Address, Country
1, John Smith, XXX, US
2, Bob Smith, XXX, UK
3, Sean Smith, XXX, US
4, Jane Smith, XXX, France

I want to create a portal on the left side of the layout which shows
the names of the contacts based on a self-join. On the right side, it
will be the record of the contacts.

How do I create the self-join?

Ken



Sun, 20 Mar 2005 15:56:47 GMT
 how to create a self-join


Quote:
> I have a flat database of business contacts. Below is some sample
> data:

> ID, Name, Address, Country
> 1, John Smith, XXX, US
> 2, Bob Smith, XXX, UK
> 3, Sean Smith, XXX, US
> 4, Jane Smith, XXX, France

> I want to create a portal on the left side of the layout which shows
> the names of the contacts based on a self-join. On the right side, it
> will be the record of the contacts.

> How do I create the self-join?

> Ken

Hello,

In that case, since you want to see the list of all contacts no matter which
record you're currently viewing, you will need a "constant" field (auto
entered data = 1) as the match field for your self-join (both sides of the
relationship). Then in the portal, apart from names, you can add a button to
go to the related record. This button uses the same relationship, something
that I don't really understand... but hey it works :)

Once there are more contacts than visible rows in the portal, you will find
that the selected row may not always be visible, that is, after selecting a
row, the portal will redraw to show the rows from the top. So it is not
always clear which line you're editing. Bridget Eley posted a solution to
that problem a few monts ago. Look in the Google archive for her post titled
"Re: How do you highlight the selected Record".

Good luck !

Marc-Andr Paiement
Montreal



Sun, 20 Mar 2005 17:54:21 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. How to create a self join in English Query domain editor

2. HELP: Creating value list with calculation/self-join???

3. Self join VS equi join

4. Inner Join / Self Joins help!

5. Self Join vs Join between different tables

6. self-join

7. Self Left Outer Join

8. Self-join

9. Self JOIN query (I think)

10. Update problem using self-join criteria

11. Self Join/LeftJoin problem

12. Self join query get wierd performance


 
Powered by phpBB® Forum Software