Avatar

Please consider registering
guest

sp_LogInOut Log In sp_Registration Register

Register | Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_Feed Topic RSS sp_Related Related Topics sp_TopicIcon
Application Designer: Create Child Records with Relationship to Parent
August 1, 2016
12:43 pm
Avatar
Andrew Weaver
Member
Members
Forum Posts: 6
Member Since:
December 24, 2014
sp_UserOfflineSmall Offline

I am creating a custom application for Maximo that allows me to do some project management. I have created all of my tables and relationships and have everything setup the way it is supposed to be. My application refers to a child table that is used to store information about project rates. I have the table created and linked up with the application, so no problems there.

My issue is that I want to be able to use the “New Row” button to create a new “Rate” which is on a separate table. I want to make sure that the project number field is being set to the same value as the project number on the project.

How do I set up the project number field on the rate to auto-fill from the parent project record?

Screenshot: 

Project management

 

I tried this: http://maximodev.blogspot.com/…..imo.html 

However the issue being when I created a new Project and went to add a rate, it would populate a random project number that existed in the system. It also caused me to have to leave the detail screen, return to the list, refresh the list, and re-enter the detail screen in order for the number to autofill.

Any help would be greatly appreciated.

PS: I’m running Maximo 7.6.0.5

August 1, 2016
4:13 pm
Avatar
shauste
Member
Members
Forum Posts: 15
Member Since:
August 7, 2013
sp_UserOfflineSmall Offline

The URL you provided didn’t seem to work. So, are you saying that you want the main Project Number to populate the Project Number under the Rates table details?

August 2, 2016
8:50 am
Avatar
Andrew Weaver
Member
Members
Forum Posts: 6
Member Since:
December 24, 2014
sp_UserOfflineSmall Offline

This should be the correct link: http://maximodev.blogspot.com/…..aximo.html

 

Yes! That is exactly what I am trying to do!

August 3, 2016
3:27 pm
Avatar
Andrew Weaver
Member
Members
Forum Posts: 6
Member Since:
December 24, 2014
sp_UserOfflineSmall Offline

Still looking for a solution, any help would be greatly appreciated!

August 4, 2016
10:53 am
Avatar
Chon
Stoneham, MA USA
Admin
Forum Posts: 1118
Member Since:
March 2, 2009
sp_UserOfflineSmall Offline

Hello, Please register to see the Admin’s answer!

August 4, 2016
11:18 am
Avatar
Andrew Weaver
Member
Members
Forum Posts: 6
Member Since:
December 24, 2014
sp_UserOfflineSmall Offline

Chon said
That link has 3 different ways to map the fields together, which ones did you try?  

We were hoping to avoid the Java customization and ideally just set this link inside the Application Designer and avoid any custom scripting.

The closest we were able to get was by using the default value field, which did work. The issue being that when a new project was created the user would have to back out of the detail view, and refresh the result list, then navigate back to the project record for this to work. If the project was already created the default worked perfectly.

I believe this is caused the the results_showlist which is pulling a value out the list that is “selected.” Is there a way to set the Data Source ID to the current parent record?

August 5, 2016
11:30 am
Avatar
Chon
Stoneham, MA USA
Admin
Forum Posts: 1118
Member Since:
March 2, 2009
sp_UserOfflineSmall Offline

Hello, Please register to see the Admin’s answer!

January 19, 2018
8:01 pm
Avatar
Carlos Galindo
New Member
Members
Forum Posts: 1
Member Since:
November 22, 2013
sp_UserOfflineSmall Offline

Have the same requirement…tried but nothing happened

Forum Timezone: America/New_York

Most Users Ever Online: 54

Currently Online:
1 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

sun kim: 60

madd0g17: 59

v.barsamov: 51

cgregory: 45

Maximofresher: 45

matta0990: 33

Member Stats:

Guest Posters: 0

Members: 14366

Moderators: 0

Admins: 4

Forum Stats:

Groups: 1

Forums: 8

Topics: 1580

Posts: 4295

Newest Members:

Megan Morgan, Devendra Verma, stephen stephens, maxexpertise Hilal, Jeroen van Proosdij, Neeraja N

Administrators: Chon: 1118, kristensibilia: 0, Joe Grassia: 0, bpaik: 0