Can I use a picker to list all of the record ID's in a specified table and then display certain fields related to the specific record ID chosen?

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

I have two tables, Devices and Cables.

On a form in Cables I need a drop down list of all the record ID's in Devices.

Once a particular record ID is chosen from the list I need 5 fields associated with that ID to fill on the Cables form.

Essentially I need Device information to auto populate on the Cables form when a record ID is selected.

Is this even possible?

Photo of Jason

Jason

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,320 Points 50k badge 2x thumb
No problem,

Just make a Relationships between the two tables.  Here is some help on Relationships.

http://www.quickbase.com/user-assistance/Default.html#about_relationships.html


Post back if you get stuck anywhere.
Photo of Jason

Jason

  • 0 Points
Thanks for the response! Well, I have a relationship between the tables, a device has many cables. I can associate a form from Cables to a Device no problem if I initiate a new Cable from a newly added Device. But I need to initiate a new Cable from the Cable table, then pick which device to associate it too using a record id#. I will also need certain information about that Device to auto populate in the new Cable form once that id is selected. I found a page that explains things like this: "Try putting the reference field (Related Device) or reference proxy (Device - Make) on the Cable form.  Those are both dropdowns that populate a complete list of the Devices and then auto-populate certain fields/data when a Device is chosen." Would that work?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,320 Points 50k badge 2x thumb
Let's take a step back here because you probably need a many to many table.

One Device has many Cables.
But I will bet'ya that a Cable can be used for more than 1 Device.

So you will need to have a new middle join table called Device Cable Assignments.

1 Device has Many Device cable Assignments
1 cable has many Device cable Assignments.

 So just delete your existing relationship and start over
Photo of Jason

Jason

  • 0 Points
Spot on. After doing a little reading up on Many to Many relationships, I have what I need. Thanks!
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,320 Points 50k badge 2x thumb
Man o Man you are now a database guru.  Excellent.  It all becomes obvious in hindsight, doesn't it?  But you gotta experience every situation once. :)