I have a requirement of filtering two tables with two common fields. If I concatenate fields i wont get fields available to be put in filter pane separately. Suppose Table 1 has date,name,marks,DOB,birthmark,country and Table2 has date,country,address,zone and state as fields. date and country are to be put as common filters for both tables. Help is appreciated.
Hi! First of all,Thank you for your efforts. Could you help me with filter pane too. If i make the composite key like you have demonstrated, I don't find any way how i can put both fields as common filter.
Saksham, have a look at the following Design Blog posts, I think it may help explain things and potentially help you with getting what you want in your data model. There are hundreds of other posts in this area as well, so I will also include the base URL for you, so you can further search for other posts if you like.
In this case, I would think it may be better to join the tables into a single table, but I am sure you have reason for keeping them separate, more info on the use case may help on this one...
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.