3 Replies Latest reply on Apr 6, 2014 7:17 AM by philmodjunk






           I've been reading the manual and experimenting for hours.  I just can't figure it out...
           How do I get info from CLIENT table to another table?  Do all fields have to match?  The info in the second table does not need to be modified, only displayed.  Would I do this through a "portal"  Can someone PLEASE point me in the right direction?


           Thank you.


        • 1. Re: Relations...

               Hi Troy

          It would be easy to help you if you can say exactly what data to which table you want to display as you have already shared the TO graph.




          • 2. Re: Relations...


                 I've been working on it, so I've included an updated graph.  What I'm looking to do is have a Drop Down list in my Invoice table that I can select a last name from the Client table.  Once selected, the full name (First & Last) and address populate on the Invoice table. 

                 Thank you


            • 3. Re: Relations...

                   From the relationships shown, your invoices table will need to show "invoice copy" in Layout Setup | Show Records From. But if you have an established layout based on Invoices, then this could make the relationships shown workable for your layout but keep existing parts of your layout from working.

                   See this thread for how to get your data from a related table to appear. (No portal needed for this relationship since you would have only one client for each invoice.)

              Auto Fill