Forum Discussion

Qrew Captain

3 years ago

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...

Relationships

Tables and fields

ChrisNewsome

Qrew Captain

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
------------------------------

MarkShnier__You

Qrew Legend

3 years ago

I 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
------------------------------

ChrisNewsome
Qrew Captain
3 years ago
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__You
  Qrew Legend
  3 years ago
  The 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
  ------------------------------
  - ChrisNewsome
    Qrew Captain
    3 years ago
    I have no problem with changing it, I certainly trust your expertise Mark. I learn something new every time I talk to you.
    
    ------------------------------
    Thanks,
    Chris Newsome
    ------------------------------