linking different tables

[Anonymous]

Hi All

i am facing a problem with linking the below tables what i am trying to do is when choosing the company BH in Table 1 want this selection to get me the people's name in table 2 in the same hour i.e peoples's name in the company BH

[bbi_mba_76]

Hi,

Table1 and Table5 are linked by the Key1 field?

[Anonymous]

thank you for your reply ....yes they are linked but i want to make another link let me explain more

i need 2 things :

1- get the people's name

2-the name of persons in the company BH

the current links returns the name of the person but not the time (company BH)

[jvitantonio]

Tamer, can you please post a real example? That diagram doesn't make much sense. You are linking tables with a blank field .

[Anonymous]

i hope u can understand the below graph

as shown below table 1 3 & 5 are linked together the problem is when i chose the peak hour in table 1 the result is the cells only while i need 2 things the cells and the peak  hour .

[jvitantonio]

Hi, sorry but I don't understand when you say you don't get the peak hour as you are stating that you select the peak hour. If you select the peak hour and you have the cell, then it's fine. If you want ALL the peak hours for a certain cell, then choose the cell...

[Anonymous]

the problem is that the output is the cells of the zone but in all the available hours not in the peak hour

[jvitantonio]

Sorry Tamer but it's hard to tell with your diagram. Do you think you can attach your application? You can scramble the data before sending it if you want. J

[saumyashah90]

I Would Suggest you to  do

Left Join(Table1)

Load * resident Table3;

left join(Table1)

Load * resident Table5;

Drop Table Table3 and Table5;

Load * from Table2 ;