03-23-2017 05:00 PM
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
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.
Solved! Go to Solution.
03-23-2017 05:05 PM
03-23-2017 05:50 PM
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
03-27-2017 01:21 AM
Does query merging work in your case?
Instead of splitting, you can add a new conditional column for each table as follows:
if column end with oo then oo, aa then aa, ff then ff
Do this for tables 1 and 2
For table 3 do the following:
if column ends with oo then oo, aa then aa, ee then ff, tt then ff
Merge tables 1 and 2 on that new custom column, let's name it table 4.
Merge tables 4 and 3 also on the new custom column, let's name it table 5.
You can then remove the new custom columns from table 5 and end up with this
I am not sure that is exactly what you are asking for and if your real data is actually more complex.
Let me know how it goes!
03-29-2017 04:37 PM
Thanks for the response.
Could I just add a table with those values (enter data) and then link the tables together with relationships rather than merging everything?