Forum Discussion
relationship problem
Hi all
I have trouble with relationships. Hope someone can help with this issue.
I have two lookup tables:
1.Product groups, product names
2.Currency, currency classification
and I also have 2 data tables. I have connected my data tables to the Product table. It seems ok.
However I need to use currency tables also an cannot create relationship. Only one oy of my data table is connected to the currency table. The second one creates inactive relationship. When I am trying to get data from the second table results disappear.
I have set both sided relationship.
Please help me with this issue.
Thank in advance
it looks a bit messy. I would sit down and try to redesign it if I were you, and would get rid of the bi-directional relationships which, I think, only bring problems
5 Replies
Hi LivioLanzo
I am afraid I don't understand what do you mean. But I add screen view of my data. Hope it will help.
it looks a bit messy. I would sit down and try to redesign it if I were you, and would get rid of the bi-directional relationships which, I think, only bring problems
