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
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: