Link in Two Tables

[bharatkishore]

Hello All,

                   In my application i have 3 sheets. In first i took an list box with "Lot No" and in second sheet i took an list box "IMM" and in third sheet i created an chart.

                    My problem is if i select  values  in first sheet list box i am getting the values fine. But when i am selecting the first sheet list box  "Lot No" first value i am getting minimum value for "BCShotFlowIndexA" in third sheet chart is Min value is 329 and Max value is 386.

                   But in second sheet the min and max values for "BCShotFlowIndexA" are not changing. Please give a solution for this. I am attaching my application for your better understanding.

Regards,

R.Bharat Kishore

[Gabriel]

Hi,

Is there a particular request for you to have the List Boxs separated?

1- I think there isn't key fields joining the 3 tables together, I would suggest you check the script, and follow fields names as there could be a slight differences in the naming of each fields meant to be the joining key that is not obvious.

2- Create the tables in one sheets test the relationships, if that works separate the tables if need be.

Hope that's helpful

Regards,

Gab

[bharatkishore]

HI gabsus,

                            Thanks for the reply.No i don't have any particular request like that. We can do all in single sheet. Can you please help me how to do it. I want to get the link for those tables.

                            What condition i can use for it so that i can get the link between the tables.

Regards,

R. Bharat Kishore

[Gabriel]

Hi,

Can you check your script for any fields naming that is not consistent.

Altenatively send the file with the tables in Excel file.

Message was edited by: gabsus04