0

N:M relationship filtering

I have folowing datamodel:

Snímek obrazovky 2019-04-27 v 7.51.17

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:

Snímek obrazovky 2019-04-27 v 7.59.08

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

null
    • Jorg
    • 4 yrs ago
    • Reported - view

    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

    • friml
    • 4 yrs ago
    • Reported - view

    I have already find out solution. The right data model should be like this:

    Snímek obrazovky 2019-05-06 v 10.35.29

    and the filter like this: 

    Snímek obrazovky 2019-05-06 v 10.35.47

    Now, it works as I need. 

Login to reply

Content aside

  • 4 yrs agoLast active
  • 2Replies
  • 1634Views