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

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.