This is probably simple, but I haven’t figured it out yet.
I have two tables – Originators (containing ID#, Originator, Organization, and Phone#) and Trouble Reports (containing Autonumber, Originator, Organization, Phone#, Trouble Description, Solution).
I’ve got the Originator field in the Trouble table to read the Originator field in the Originators table. What I now want to do is if “Joe” is selected as the Originator, then Joe’s Organization and Phone# would automatically fill in. I just can’t figure out how to do this. Can anyone point me in the right direction? Thanks.
