Subject RE: [IBO] Lookup sizing issue
Author Daniel Jimenez
Hi Helen,

>And you still haven't confirmed what kind of linkage you are using
>here. It should not be master-detail
<http://geo.yahoo.com/serv?s=97359714/grpId=402930/grpspId=1705007183/msgId=
41394/stime=1178501099/nc1=4507179/nc2=3848551/nc3=3848642>

The Grid:
- DataSource points to the IB_Query for T1,

The LookupCombo:
- CustomPopup points to the LookupList.
- DataSource points to the IB_Query for T2.
- DisplayField points to MT_DESCRIPTION;
- GridLinks --> MT_DESCRIPTION=ACM_MACRO.MACRO_MT_TYPE.

The LookupList:
- DataSource points to the IB_Query for T2.
- GridLinks --> MT_DESCRIPTION

The T1 query is:

SELECT
MACRO.MACRO_ID,
MACRO.MACRO_MT_TYPE,
MACRO.MACRO_DESCRIPTION,
MT.MT_DESCRIPTION AS MacroType
FROM ACM_MACRO MACRO
LEFT JOIN ACM_MACROTYPES MT
ON MT.MT_TYPE = MACRO.MACRO_MT_TYPE

KeyLinks = MACRO.MACRO_ID
KeyLinksAutoDefine = false
KeySeeking = false

ColumnAttributes Macrotype = computed


T2 query is (used by the LookupCombo, LookupList) :
Select *
From ACM_MACROTYPES

Keylinks --> MT_TYPE = ACM_MACRO.MACRO_MT_TYPE
KeyDescLinks --> MT_DESCRIPTION = Macrotype
KeyLinksAutoDefine = false
KeySeeking = true
KeySource --> The IB_Query for T1

I hope this is the information your requested.

regards

daniel


[Non-text portions of this message have been removed]