autoupdate another field based on entered value by grabing value from parent table (1 Viewer)

maheshashish

Registered User.
Local time
Tomorrow, 02:27
Joined
Feb 22, 2017
Messages
20
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
 
Last edited:

Ranman256

Well-known member
Local time
Today, 16:57
Joined
Apr 9, 2015
Messages
4,339
You run an update query to update the fields on that record.

Te query joins the table on MEDCODE.
 

Users who are viewing this thread

Top Bottom