N:M relationship filtering
I have folowing datamodel:
MB - is database of motherboards
RAM - is database of RAM
MB-RAM - is database of compatibility of MB <-> RAM
Config - databas of configuration of PC
One type RAM can by compatible with more than one MB and one MB can by compatible with more than one RAM = N:M relationship
If I use filter in form Config to offer only RAM compatible for specific MB:
It doesn't show RAMs that are compatible with more than one MB, just RAM that are compatible with only one MB.
Any sugestion?
2 replies
-
Hi,
I have sent you an separat e-mail in order to make an Appointment with for a screensharing meeting. Then we could have look on it together.
You are also invited to join our webinar and bring your question up there.
At our Ninox webinar tips and tricks will be presented in the first 30 minutes, the remaining 90 minutes will be used for a live support where the participants' concerns will be solved.
You can register here for the webinar, which takes place every Tuesday at 18 o'clock CEST: https://zoom.us/webinar/register/WN_zoSk2qyNSz6vLRFF1zlakg
Best regards, Jörg
-
I have already find out solution. The right data model should be like this:
and the filter like this:
Now, it works as I need.
Content aside
- 5 yrs agoLast active
- 2Replies
- 1636Views