autoupdate another field based on entered value by grabing value from parent table

[maheshashish]

Respected Members,

I have a table Med_List
has fields
[drugname]
[form]
[taxpercent]
[medcode] (Medcode is concatenated of drugname and form)(PK)
etc

Another table Purchse_detailsT
[medcode] (lookup)
[purchaserate]
[qty]
[taxpercent]
Now i am having a datasheet from
which has fields all fields from Purchase_detailsT

i want the tax percent to be autoupdated with right number by finding it from Med_List table, when ever i select the medcode in the form. can some help me with this

 

[Ranman256]

You run an update query to update the fields on that record.

Te query joins the table on MEDCODE.