Autogenerate field

[mdougherty]

I have two fields in Work Orders....Equipment Priority and Task Effect.  Equipment priority is taken from the asset application.  Task Effect is entered by the using.  How do I make it so the work order priority field auto calculates based on the equipment priority and task effect?

For instance, Equipment Priority = 5 and Task Effect = C, so Work order priority, based on the table we have, would equal 3.

[JohannesT]

Consider creating a custom table called WOPRIORITY. This would store the matrix of Equipment priority, Task Effect, & WO priority. Then associate the WO priority field with a crossover domain referring to the custom table.

[mdougherty]

Thanks for your reply.  I was hoping to one day receive one.  I am not 100% sure I am following.  So I should create a custom table domain called WOPRIORITY.  What would I select for the objects and would I need a where claus??  Also, can you give an example how a crossover domain works?  I am pretty much only familiar with the basic domains.  Thanks.

[Today]

• How to get list data whic... by kvnaresh [Today at 12:39:03 am]
• How to change an email ad... by kvnaresh [Today at 12:25:57 am]
• Difference between fixpac... by jithu1989 [Yesterday at 05:25:18 am]
• Maximo Programmer Require... by ravikorukonda [February 06, 2012, 05:59:58 pm]
• Demo Maximo 7.1 Online by hyubby [February 06, 2012, 11:05:43 am]
• Error loading the Object ... by G Jeevan [February 06, 2012, 07:21:36 am]
• plzz attribute in another... by Dileep Kumar [February 06, 2012, 07:02:09 am]
• Jpeg attachments within M... by zenagarfield [February 02, 2012, 02:02:53 pm]
• How to change senders ema... by zenagarfield [February 02, 2012, 10:28:06 am]
• Lead and Crew by G Jeevan [February 02, 2012, 07:08:45 am]