Re: [RBASE-L] - Forms - Tables in Forms - Custom Table Relationships
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 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 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 > <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> >> 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 >> <mailto:myron.fineg...@gmail.com>> wrote: >>> >>> The conversation. Design a form > from the menu bar on the top of the >>> screen choose 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 >>> 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 . The issue: the functionality >>> of using the stops functioning, meaning >>> you can't link columns. The question: can a form become corrupt where >>> the functionality of 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,
RE: [RBASE-L] - Forms - Tables in Forms - Custom Table Relationships
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 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 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> 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 mailto:myron.fineg...@gmail.com> > wrote: The conversation. Design a form > from the menu bar on the top of the screen choose 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 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 . The issue: the functionality of using the stops functioning, meaning you can't link columns. The question: can a form become corrupt where the functionality of 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.
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 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 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 On Behalf Of Albert > Berry > Sent: November 26, 2018 9:05 AM > To: 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 wrote: >> >> The conversation. Design a form > from the menu bar on the top of the >> screen choose 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 >> 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 . The issue: the functionality >> of using the stops functioning, meaning >> you can't link columns. The question: can a form become corrupt where >> the functionality of 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. >> 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. > > -- > 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. -- 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.
RE: [RBASE-L] - Forms - Tables in Forms - Custom Table Relationships
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 On Behalf Of Albert Berry Sent: November 26, 2018 9:05 AM To: 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 wrote: > > The conversation. Design a form > from the menu bar on the top of the > screen choose 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 > 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 . The issue: the functionality > of using the stops functioning, meaning > you can't link columns. The question: can a form become corrupt where > the functionality of 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. > 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. -- 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.
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 wrote: > > The conversation. Design a form > from the menu bar on the top of the > screen choose 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 > 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 . The issue: the functionality of using the > stops functioning, meaning you can't link > columns. The question: can a form become corrupt where the functionality of > 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. > 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.
[RBASE-L] - Forms - Tables in Forms - Custom Table Relationships
The conversation. Design a form > from the menu bar on the top of the screen choose 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 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 . The issue: the functionality of using the stops functioning, meaning you can't link columns. The question: can a form become corrupt where the functionality of 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. For more options, visit https://groups.google.com/d/optout.