Select multiple value in linked table

i have a table with car models I sell and a table with cars components.

I have table with replacement parts that fit more than one model of car.

In the repair table I wanted to display only the replacement parts of that model or the replacement parts that have no model selected. (Is it possible to do this with formulas?)

I saw that by connecting the model table to the replacement parts table the field does not allow me to make a multiple choice, what can I do?

Thanks for your invaluable help.


1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • Fred
    • Fred
    • 5 mths ago
    • Reported - view

    Hi Mauro -

    Let me see if I understand the structure. You have the following tables:

    car model (i.e. Audi eTron, Toyota Camry, Kia EV6)

    components (headlights, cam shaft, shocks)

    replacement parts (headlight1, headlight2, cam shaft1, cam shaft2, shock1, shock2)

    If this is true then it looks like there is 1:N (1 to many) relationship between model and components, and between components and replacement parts.

    In Ninox you create the reference field from the many side so you would create a reference field in replacement parts to components. Then create a reference field in components to model.

    Once all the links are created you can see which replacement parts for headlights are for the Kia EV6.

Like Follow
  • 5 mths agoLast active
  • 1Replies
  • 42Views
  • 2 Following