Default value in a field

Yahoo Archive
1
Hi Jeff,

You should store the labor rate somewhere to avoid hard-coding these labor
rate values. I would start with customizing your Job Department Maintenance
screen and add a JCDept.Number01 bound text field to the screen. Then,
populate each job department with a labor rate.

When that is done, create a pre-processing BPM on the EmpBasic.Update method
that will look up the value from the JCDept table and add the Number01 value
to the labor rate field in EmpBasic table.

When you get the customization finished, let me know and I can walk you
through the code details of the BPM if needed.

Ross

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
jplehr
Sent: Wednesday, June 02, 2010 8:03 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Default value in a field

Vantage 8.03.408A

Don't even know where to start on this one. Looking for some detailed
direction.

The particular scenario is in Employee Entry. You have the drop down option
to select the Home Department. I would like the Labor Rate to populate the
appropriate field based on the department selected.

Anyone. Thanks much.

Jeff



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
2
Vantage 8.03.408A

Don't even know where to start on this one. Looking for some detailed direction.

The particular scenario is in Employee Entry. You have the drop down option to select the Home Department. I would like the Labor Rate to populate the appropriate field based on the department selected.

Anyone. Thanks much.

Jeff
3
Jeff,



I assume you're using a standard labor rate that you've already
predetermined based on department. A form or table would be needed to
maintain that relationship, such as a UD table. We could then take one
of two trips at this point. Either use a BPM when the record is saved
to populate the labor rate fields accordingly, or, we could use a VB
script when the department is changed to do a BO connect to that UD
table and subsequently populate the fields as well. I guess it all
comes down to how particular you are to the timing of when the field
populates. When the save button is hit, or when the department is
selected.



Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

Mobile: (715)896-0590

FAX: (715)284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site) <http://www.dsmfg.com/>





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of jplehr
Sent: Wednesday, June 02, 2010 8:03 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Default value in a field





Vantage 8.03.408A

Don't even know where to start on this one. Looking for some detailed
direction.

The particular scenario is in Employee Entry. You have the drop down
option to select the Home Department. I would like the Labor Rate to
populate the appropriate field based on the department selected.

Anyone. Thanks much.

Jeff





[Non-text portions of this message have been removed]