I'm trying to use a drop down list from another table to fill in other Fields when adding a new record

Question

I'm trying to use a drop down list from another table to fill in other Fields when adding a new record. For example I have a providers list table and in each record it has the clinic name, NPI, and doctor. On my records table I created a drop down list from that table for the clinic names I'm trying to get it to also fill in the NPI and provider. I can do this in the dynamic form rules but I was wondering if there's an easier way

quickbasecoachd · Answer

np, Quick Base has "Relationships" designed to do exactly that.

https://help.quickbase.com/user-assistance/creating_a_relationship.html

Post back if you need help or if you have a lot of existing data in your app for the current provider in your records table and I can help you not have to do that data entry again.

alexandraochoa · Answer

Thank you!

Forum Discussion

I'm trying to use a drop down list from another table to fill in other Fields when adding a new record

Related Content

Moving Fields from One Table to Another

Trying to calculate On Time delivery

Trying to Create a Attendance Checklist

Snapshot Fields

Trying to create a report with an ask users filter, but with a multiselect