How to show fields from another table?
Hi Guys, I am fairly new to FileMaker. I am working with Oracle and use PL/SQL. I am trying to populate some fields in a form, when a value is entered in another one. I have a table called Purchase Order and another one called Vendor Table. My form should fetch and show fields like Vendor Address and Fax number from Vendor table and show them as individual fields on the purchase Order form, when the user inserts the Vendor Name.I can't figure it out, how it should be done. Can you please help me with your expertise? Thanks, Megan