Data Modelling

[krishna20]

Hi Folks,

I got struck on a requirement in the modelling part.

Tab1

A

B

C

D

E

F

Tab2

1

2

3

4

5

Tab3

abc

def

ghi

jkl

mno

I'm having three tables which is linked properly. (here i have not mentioned the key).

When i click on the value 'A' in Tab1, the possible values in Tab2 is '2' and in Tab3 is 'ghi'.

I need to restrict the value 'A' from Tab1 and the possible values to it.(The value 'A' need to hide)

The values '2' and 'ghi' from tab2 and tab3 may be a possible values to another values in the tab1.

I need to restrict only for 'A' from tab1 .

Please suggest me some logic to restrict the data.

Regards

Krishna

[tyagishaila]

these values are showing because

as you said,

The values '2' and 'ghi' from tab2 and tab3 may be a possible values to another values in the tab1.

[engishfaque]

Dear Krishna20,

Here is script,

Table:

Load

        *

From YourTableName

Where Tab1 <> 'A';

Kind regards,

Ishfaque Ahmed

[krishna20]

Hi sorry,

I can't upload a sample file. Uploading data is restricted. Give me some time i will try to explain with images

[avinashelite]

could you try with the Exists() function keyword , share the Key column so that we can base the solution out of it