Hi experts!
How are you? I don't see how can I find a workaround to this issue. I just want that Excel interprets as the same object a field (column) that I use in 2 different tables.
I have two tables:
- a table named tblCampaigns in which one of the columns is called Category
- and another table for tblContacts which also has a Category field (that means the same in the Campaigns table)
This Category field is validated by a fixed drop-down list of unique (non-repeated) categories pre-built somewhere else in the excel file. Just for your information, this list has been also created technically as a table called lstCategories.
So I thought that if I built a relationship between tblCampaigns.Category with lstCategory I could also relate lstCategory with tblContacts.Category and the data model would understand that both fields are the same thing. This is not possible as a message warning duplicated relationships pops up.
Do you know any other way?
Thanks!
Gerónimo
Bookmarks