telmiger
Posts: 61
|
| Posted: 03/10/2004, 12:15 PM |
|
Hi
I build a grid from 2 tables (clients and contacts)
The query used to build the grid has a left joint.
When clicking on the link in my grid record I would like to transfer the client_id, as well as the contact_id.
I got it to work if I modify the query to a inner join. But if I use a left join the contact_id is empty.
Is there a workaround to make it work for a left join.
What I am trying to accomplish is the following.
If I click on the record link in my grid it will display to forms.
The first form is for the client information and the 2. form is for the contact information.
If I use the inner join the grid does not list any clients that do not have a contact entered.
Any hints would be appreciated
Tony
|
 |
 |
peterr
Posts: 5971
|
| Posted: 03/10/2004, 12:29 PM |
|
Possibly you could paste your query here.
Also, is contact_id always empty or only for certain records?
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
telmiger
Posts: 61
|
| Posted: 03/15/2004, 8:21 AM |
|
telmiger
I ended up using a inner join between the 2 tables. The workaround I did to make sure the records would show up in the grid is the following:
In my client form I entered an after insert function that will insert an empty contact record with only the client Id reference.
This way I will always see the record in my grid and I can use the multi column primary key.
TonyE
|
|
|
|
|
