Lookup Fields / Drop down options
So I'm trying to accomplish a couple of things here. First, we install custom closets. So I have a table called "Installations" which is used to schedule the jobs (installs). I have a separate table c...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendI'm a bit confused. You said that you had a relationship where One Installer has many Installations based on a field called, say, Related Installer #1. Then you are looking up their userid and their name, I suppose.
But in your post you referred to a multiple choice field to select the installer? What is the Key field of your Installer table?
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
But in your post you referred to a multiple choice field to select the installer? What is the Key field of your Installer table?
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Yes so originally I set up a Text - Multiple Choice field where the input type is set as "from another field" and points to the installer table / name field. The key field is always the Record ID for my tables.
------------------------------
Thanks,
Chris Newsome
------------------------------
------------------------------
Thanks,
Chris Newsome
------------------------------
- MarkShnier__YouI suggest that you Copy you app to make this suggested change before implementing in your live app.
Change the Key field of the Installer Table to be the Installers Name field. Then make a relationship where one installer has many installations based on that existing field.
If you have an Installer 2 field, then you will make a second relationshp.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------- I will try that. It didn't even occur to me to change the key field. I'll let you know what I run into.
Thanks!
------------------------------
Thanks,
Chris Newsome
------------------------------- MarkShnier__YouThe purpose of changing the key field is to attach all your existing Installations to the correct installer. If you like you can then change the Key field back to [Record ID#]
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------