Subject | RE: [IBO] Lookup sizing issue |
---|---|
Author | Daniel Jimenez |
Post date | 2007-05-07T02:33:29Z |
Hi Helen,
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]
>And you still haven't confirmed what kind of linkage you are using<http://geo.yahoo.com/serv?s=97359714/grpId=402930/grpspId=1705007183/msgId=
>here. It should not be master-detail
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]