On 24 Sep 2003 at 11:05, James Hageman wrote:
> I have 3 tables, [main], [building], and [department]. Main has FKs for
> Building and Department. I want to know what departments i have in
> certain buildings (maybe more than one)
>
> I first get the Building FK here: (I can choose by building name and
> return the building key)
>
SET VAR vTitle TEXT = NULL
> CHOOSE vbuildcode FROM #VALUES FOR building_name, building_id +
> FROM building +
> ORDER BY building_name LINES 25
>
> Then I get the Department FK based on the first CHOOSE:
SET VAR vTitle = ('Please choose whatever for' & .vBuildCode)
>
> CHOOSE vdeptcode FROM #VALUES FOR DISTINCT (department_code & [[ name of
> dept from dept table]]), department_code +
> FROM main +
> WHERE building_code=.vbuildcode ORDER BY department_code +
AT CENT CENT
TITLE .vTitle
CAPTION 'Please Select'
>
> What I want to to be able to also have the name of the department show
> up in the second choose, but I can't figure out how to do that.
>
>
Victor Timmons
Tiz's Door Sales, Inc
425-258-2391
