Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I'm creating a new table and the typical green-white-gray will not work when I create a list box for CMPNY_CODE even though I see the tables are auto joined correctly by CMPNY_CODE.
COMPANY_CODES:
LOAD
CMPNY_CODE_ID,
REGION_NAME as CMPNY_REGION_NAME,
CMPNY_CODE_FULL_NAME &'-'& COUNTRY_NAME &'-'& REGION_NAME as COMPANY
FROM
I've seen this happen in a couple of places.
Right-click the object and make sure that it is "Attached."
If there is an option to Attach it, do so. Otherwise it may be associated with an alternate state.
It's strange. I have no option to attach and the alternate state is = "inherited".
I don't see 'CMPNY_CODE' in the load script you posted. Can you screenshot your data model ?
Here's my latest script. Getting the same behavior:
COMPANY_DESC:
add LOAD CMPNY_CODE_ID,
CMPNY_DESC,
CMPNY_CODE_ID&'-'&CMPNY_DESC as COMPANY
FROM
Whoops. Here's the data model:
I assume you're looking at CMPNY_CODE_ID for your list box.
It may well be that even though the fields are named the same, they are not linking because you have some white space or something causing them to be different. Try Trim(CMPNY_CODE_ID) as CMPNY_CODE_ID in your load script.
For both tables.
Can you check that the COMPANY_DESC is not loosely coupled like below image
You can check this in Setting>> Document Properties >> Tables
Will try. Thanks.