Forum Discussion
Making a table to connect different tables
I am trying to connect 3 tables that have different 'Resources' for each value.
Table 1 Table 2 Table 3
COO FOO BOO
CAA FAA BAA
CFF FFF BEE
BTT
So in table 1 COO equates to FOO in table 2 and BOO in table 3. Table 1 CAA equates to FAA in table 2 and BAA in table 3. However, Table 1 CFF equates to FFF in table 2 and BEE and BTT in table 3.
I can connect Table 1 and Table 2 easily by making a new table that has these values in different columns and then making relationships between the original table and the new table.
The problem is because CFF=FFF=BEE and BTT. I don't know how to put BEE and BTT in the linking table to connect the tables.
Any ideas?
Cheers
Of course you can!
If you need them to stay separate, forget about the merging and the new table you mentioned, and just do this
7 Replies
Could you ssplit the data into two columns?
So have Table1 as follows and just link up on Col2?
Col1 , Col2 --------------
C ,OO
C ,AA
C ,FFFHi Phil,
That still doesn't solve the problem that there are 3 entities in Table 1, 3 in Table 2 and 4 in table 3.
Could you create a new column in Table 3 to combine the two values into just 1 value?
So still split as suggested, but create a simple formula to say for Table three
where values are X & Y, then just make then X for the purpose of linking
