Forum Discussion

meIdo's avatar
meIdo
Icon for Helper I rankHelper I
3 years ago

Data not filtering

Hi Guys! I have 2 tables. One contains member data, shoping date and shop type, Other one contains shopping frequency (Summary) like how many shopping in Jan, Feb .... and there is no member data bu...
Need Help
HoangHugo's avatar
HoangHugo
Icon for Solution Specialist rankSolution Specialist
3 years ago

Hi, you can create one more relation between Shop type Data and Shop Type Frequency (many to many or one to many). OR create one more middle table to connect two table by Shop type as well as Date table

meIdo's avatar
meIdo
Icon for Helper I rankHelper I
3 years ago

I did that but it says only one relation should be active..