Forum Discussion

FerasAlramli's avatar
FerasAlramli
Qrew Member
5 years ago

Forms

Hi Everyone , I'm new to Quick Base and this my first post , I need help for below scenerio 

Three tables :
                  Customers,
                  Items,
                  Order
Relationship:
                  one-many        customer-->orders  ,
                  one-many        order--->items


when I add new order , customer picked correctly, 

Problem: 
created default form asked me to enter new items where I want to select from existing item table and showing the unit price and allow the users to enter quantity and change unit price only.








------------------------------
Feras Alramli
------------------------------
  • Hi Feras,

    What you are looking to make is actually called a Many to Many relationship between orders and items. This is done by having a set up like:

    one-many orders-> (New Join Table-called line items or order items for example)
    one-many items-> (New Join Table-called line items or order items for example)

    What this allows you to do is have a relationship where you select an order and then select an item on each line item record and then add quantity and any other specific info for each line item. This allows you to get the functionality you are looking for that an order can have many items under it pulled from a menu of items. You can learn more about Many to Many relationships right here in University to get you started under our complex relationships lesson. If after reviewing the lesson you would like some help putting it into your own application you can also always reach out to our Care team for some one on one help building that relationship via a support case by clicking Support where it appears in the upper right hand corner here on the Community or when signed into Quick Base by clicking the question mark (?) icon that appears in the upper right hand corner and selecting "Manage Support Cases" to create a new case. I hope the suggestion is helpful Feras.

    ------------------------------
    Evan Martinez
    Community Marketing Manager
    Quick Base
    ------------------------------
    • FerasAlramli's avatar
      FerasAlramli
      Qrew Member
      Hi Evan, 

      Thanks for your help , it's clear and working.


      ------------------------------
      Feras Alramli
      ------------------------------