How can I ceate a lookup on INVVENDOR table in maximo 6.2.1? I looked on the lookup.xml file and there is no table id for INVVENDOR. Is it possible to add a table id to the lookup.xml?
I want to link an attribute in the ASSET table to the INVVENDOR table to get the list of the latter.
I appreciate your help. Thank you
NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
This topic has been locked.
15 replies Latest Post - 2011-03-08T19:14:42Z by maxmadman
Pinned topic Creating a lookup
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2011-03-08T19:14:42Z at 2011-03-08T19:14:42Z by maxmadman
Re: Creating a lookup2008-03-17T14:24:17Z in response to SystemAdminYes, you can add the INVVENDOR table in the lookups.xml and you can specify the fields you want to appear. But you also have to create a maxdomain and a maxtabledomain record. Then you must set the domainid of the field you want to use the lookup.
SlightlyCrazy 2700007F3F59 PostsACCEPTED ANSWER
Re: Creating a lookup2008-03-23T22:35:45Z in response to SystemAdminJust for reference, to create a new lookup you potentially have to do up to three things:
1) Create a table domain\crossover domain which identifies the source table against which the lookup is to be performed - this is how MAXIMO identifies what records to be referenced when building the lookup.
(done within the domains application)
2) Create a new entry within the System lookups.xml. You can repeat an existing entry providing you give it a unique name. You identify which columns you want to display, and the order in which they are displayed. You also get to specify column headings, whether the filter is available and whether it is open etc. Effectively this component defines what the lookup actually looks like on the screen.
(done by exporting the lookups.xml system definition from application designer. modifying it be hand and then reimporting it back through the application designer)
3) You may also need to add one or more entries to the MAXLOOKUPMAP table in order to assist MAXIMO in determining how to copy details from the selected record. Typically you need to do this because MAXIMO can not work out which values to copy where - giving you the 'invalid customisation message'. You don't always need to do this. (done through SQL - no GUI version)
rad3 100000QVBA24 PostsACCEPTED ANSWER
Re: Creating a lookup2008-06-23T13:43:24Z in response to SystemAdminHi,
After creating a table/cross over domain,
and adding lookup (we can define here the order, look of the data to be displayed in the select box),
please tell me how I can use maxlookupmap to select a certain column value into the target field.
Re: Creating a lookup2008-06-23T21:09:11Z in response to rad3the maxlookupmap table has a very small record (only 9 fields), so you have to insert a record into maxlookupmap when you create a new table domain. so for example, say your new tabledomain is associated with a custom table named "CCMASTER" and this custom table domain is listed on the DEPARTMENT field of the custom CCMASTER table (because you want all CCMASTER records to have valid department names that are validated against the custom DEPTMASTER table), the values you would have to insert into maxlookup map are as follows:
TARGET -> CCMASTER
LOOKUPATTR --> DEPARTMENT
TARGETATTR --> DEPARTMENT
SOURCEKEY --> DEPARTMENT
SEQNUM --> 1
ALLOWNULL --> 0
SOURCE --> DEPTMASTER
anyway, this is how i've gotten it to work...
YelloY 2700006Q1828 PostsACCEPTED ANSWER
Re: Creating a lookup2008-08-05T06:30:03Z in response to SystemAdminProcessor, where can I find Field Control?
Is it included in an extra package? I do have Maximo 7.1 installed, but there is no such appliaction. I've been using it some time ago with version 6.x - but then it required additional installation.
tanweer 28000001UN28 Posts
Jeffery.Carlisle 270003JKH51 PostACCEPTED ANSWER
Re: Creating a lookup2010-12-21T01:15:34Z in response to SystemAdminLeonardoBastos wrote:
Yes, you can add the INVVENDOR table in the lookups.xml and you can specify the fields you want to appear. But you also have to create a maxdomain and a maxtabledomain record. Then you must set the domainid of the field you want to use the lookup.
It's good for reference, Thanks for your sharing! It's helpful to me.