You are more than welcome. I have received so much help from others on this forum and its predecessors since 1984 I feel honour bound to return the favour. Albert
> On Nov 26, 2018, at 3:19 PM, Myron Finegold <myron.fineg...@gmail.com> wrote: > > 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 > <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 >>> <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 >>> <https://groups.google.com/d/optout>. >> >> -- >> For group guidelines, visit >> http://www.rbase.com/support/usersgroup_guidelines.php >> <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 >> <https://groups.google.com/d/optout>. >> >> -- >> For group guidelines, visit >> http://www.rbase.com/support/usersgroup_guidelines.php >> <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 >> <https://groups.google.com/d/optout>. > > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > <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 > <https://groups.google.com/d/optout>. > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > <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 > <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.