Don Orrell
|
| Posted: 07/09/2001, 2:55 PM |
|
I am trying to use a join on a Label to show another field from the
relationed table. However, it appears to be a one-to-one relationship. I
need a zero-to-one relationship. In otherwords, the field is not required
so it may not contain any data. It seems the grid will not display the
record when this foreign key is missing. An example is like not having the
department in which a employee works in the EmpDir example. The grid will
not show the employee if no department key is in the employee table.
It there a work around without changing the structure of the database?
Don Orrell
|
|
|
 |
CodeCharge
|
| Posted: 07/09/2001, 3:20 PM |
|
This is an issue because we used straight JOIN.
We have changed it by adding new JOIN options in the upcoming Upgrade to
version 2.0.
Until then, please use DLookup function.
For example include field employee_id on your form, then place this code in
the "Before Show" Event:
fldemployee_id = DLookup("employees","employee_name","employee_id=" &
fldemployee_id)
Adam
"Don Orrell" <dorrell@favoritenurses.com> wrote in message
news:9id993$lkf$1@news.codecharge.com...
> I am trying to use a join on a Label to show another field from the
> relationed table. However, it appears to be a one-to-one relationship. I
> need a zero-to-one relationship. In otherwords, the field is not required
> so it may not contain any data. It seems the grid will not display the
> record when this foreign key is missing. An example is like not having
the
> department in which a employee works in the EmpDir example. The grid will
> not show the employee if no department key is in the employee table.
>
> It there a work around without changing the structure of the database?
>
> Don Orrell
>
>
>
|
|
|
|
|
