How do I get a field to automatically put a value based on another

[Ridnaway]

I have a database for employees. I'm trying to get a field named
billing_rate to automatically populate once the name of the employee is
placed onto a form.

 

[Scott L. Heim [MSFT]]

Hi,

Assuming the table that has the billing rate also contains a field that
will reference the employee you are going to enter (in other words these
tables are related some how) or it is one in the same table, you are going
to need to use a "Rule" on the field where you are entering the employee,
where the Action of the Rule is "Set a Fields Value."

You would then need to add a "Filter" to the Rule so that it pulls the
billing rate based on the employee entered.

Here is some additional information on this:

http://blogs.msdn.com/infopath/search.aspx?q=current()&p=1

Let us know if you need anything else!

Best Regards,

Scott L. Heim
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.