Albert, I just finished recreating the form and all works fine.
I added all the tables and the links first, then added the columns. Thanks for the help. Myron From: rbase-l@googlegroups.com <rbase-l@googlegroups.com> On Behalf Of Albert Berry Sent: November 26, 2018 2:57 PM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - Forms - Tables in Forms - Custom Table Relationships Myron, check the one to many, many to many etc. settings. Razzak has an article on these type of things on base.com <http://base.com> here: http://www.razzak.com/fte/pdf/CustomTableRelationships.pdf Albert On Nov 26, 2018, at 9:31 AM, Myron Finegold <myron.fineg...@gmail.com <mailto:myron.fineg...@gmail.com> > wrote: Albert - thanks for the response. The database has had its integrity checked and has been reloaded. And, all of the common columns have been indexed accordingly. Myron -----Original Message----- From: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> <rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> > On Behalf Of Albert Berry Sent: November 26, 2018 9:05 AM To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> Subject: Re: [RBASE-L] - Forms - Tables in Forms - Custom Table Relationships Thoughts: 1. Reload the database 2. Is the common column indexed in all the tables? Albert On Nov 26, 2018, at 8:21 AM, Myron Finegold <myron.fineg...@gmail.com <mailto:myron.fineg...@gmail.com> > wrote: The conversation. Design a form > from the menu bar on the top of the screen choose <tables> add a master table (or one has already been added). As you progress in the form development you want to add a second table (or in my case a 3rd and 4th) that has a common column. Easy, look at <tables/Views> and add the table you want. Then highlight the table (right box) and click on (settings) on the bottom. A dialog box opens and now click on <Custom Table Relationships>. The issue: the functionality of using the <Custom Table Relationships> stops functioning, meaning you can't link columns. The question: can a form become corrupt where the functionality of <Custom Table Relationships> stops functioning. I've done the form twice with the same results. Thanks for any advice. Myron -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com <mailto:rbase-l+unsubscr...@googlegroups.com> . For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com <mailto:rbase-l+unsubscr...@googlegroups.com> . For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com <mailto:rbase-l+unsubscr...@googlegroups.com> . For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com <mailto:rbase-l+unsubscr...@googlegroups.com> . For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
