Match cases

[noman212]

Hi all,

i have values  in data bases 'Y','D','I' and so on i want to display on selection if i select Y then textbox show 'Premium' if D then it becomes difference.how can i do this?please tell

[tresB]

=Match(YourDataField, 'Y', 'D', 'I', ....), 'Premium', 'Difference', ....)

[noman212]

Not showing any result

[tresB]

Note: To get a result, you have to select a value from data field.

[noman212]

[noman212]

i select field but it display none

[anbu1984]

Can you attach your app.

[Anonymous]

It seems there is no connectivity between the fields.

I hope you have two different databases,but check your table viewer whether it has the connectivity.

[noman212]

yes how can i connect these two fields

[Anonymous]

send me the sample app or send me the list of fields in two databases.