Update a Field based on prior field

[sujitagarwal]

Hello,

I have a table that has been converted into a form for an input. Now suppose I have two columns. Say I enter value in first column. Now the second column is a lookup to a data from another table.

What I want is to see only those data in 2nd Column which have the value filled in Column 1. This is should be in run time mode. I fill in the value and then in the 2nd column I directly get to see only common values.

Please help.:banghead:
Thanks in advance.

 

[Mihail]

Your question make me to think that your database is not properly normalized.
I can't see a reason to do what you are trying to do.

 

[catalin.petrut]

The principle is explained in this video.