I need a small query.

hi.

Plz have a look on below image.

i am having some tax types.

in below figure i Selected Test

in Test it is having some tax types.

what i need is..

i need to capture vat rate.

in below figure

vat rate is 4 ....

i want to run the query base on Tax code like

Select Rate from table where taxcdoe = 'Test'

how can i get the

other wise

plz have a look on second image. vat1

i need capture vat4 amount 16

Actually i need fms at row level at udf

when ever i select the tax code in tax code vat amount should be copied to the udf value

each tax contains only one vat either 4 or 5 or 6 that amount should come into udf

can i get the value..

I need your valuable suggestions..