Hitting 2 birds with one stone

Hitting 2 birds with one stone

 Hello friends,

Is it possible to fill in 2 fields at once using lookup in Creator?  My database has 2 forms: sales report and tax rates.  From the tax rates forms I have 2 fields: COUNTY and TAX RATE.  Both these fields are also in the sales report form.  Instead of using the lookup object for both, can I not just select the COUNTY and have the corresponding TAX RATE automatically filled in?  Or do I need to write a script?

Thanks!