create multiple dropdowns from relationship

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

Primary Table it JOBS.  Second table is BID ITEMS.  Each job has several bid items.  I have a third table called SCHEDULE.  each schedule can have many bid items assigned.  I would like to pick the job number, then pick several different bid items to assign to the schedule.  I have created a relation ship for the job number but am only able to bring one bid item with associated bid item data across.  Is there a way to setup to have multiple fields to select bid items based on the job number?

Photo of Joshua

Joshua

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of Blake Harrison - DataBlender

Blake Harrison - DataBlender, Champion

  • 100 Points 100 badge 2x thumb
You'll actually need to have another table to join these, much like you could have an Orders table, Products table, and a Order Items table, where you would have 1 Order Item for every Product you want on an Order. The most basic way would be to have a Schedule table and a Schedule Items table where Schedule can have many Schedule Items and Bid Items can have many Schedule Items (even though this would probably never happen, it allows you to select a single Bid Item for each Schedule Item).