1 Reply Latest reply on Jun 4, 2013 9:25 AM by philmodjunk

    Two Related Fields



      Two Related Fields


           I'm not sure that I'm using the correct terminology for this, but I have searched, and didn't really find my solution.

           I have two drop-down fields in my mail log database, and I would like that when you select one item in the first dropdown, to automatically select an entry from the second drop-down field.

           The two fields are "Form/Document" and upon logging out, we select a "Destination" for the form - to which department the document is to go after it leaves the office.  We have a few people using this database, and we're always having to look up where certain forms are supposed to go.  I figured it would be easier to relate the two fields, so that when someone selects, for example, the form "Permission to Travel", the Destination field would automatically populate to "Travel Office."

           There is a little quirk, however, and the issue is that some forms may go to different destinations depending on how the form needs to be managed.  So, the second field should be editable, in case a form has to go to somewhere besides the specific destination first.

           Thank you for any help!

        • 1. Re: Two Related Fields

               You can set up a related table of Destination records linked by your Form/Document data. Then a looked up value field option can automatically copy the typical destination into the destination field, but this will still be a text field so you can edit the looked up destination--even use a value list, when a non-typical destination is required.

               From past experience, I can warn you of one possible complication with this change--now that your database is "doing the thinking" for your users in this area, you'll find errors occuring because someone selected the a value in Form/Document and didin't stop to determine if the "typical" destination was correct for their document.

               Here's a link that spells out "looked up value" settings in more detail: Auto Fill