Thx that works for the parent but not the slave tables. Dan Goldberg
From: rbase-l@googlegroups.com <rbase-l@googlegroups.com> On Behalf Of Buddy Walker Sent: Tuesday, September 25, 2018 10:32 AM To: rbase-l@googlegroups.com Subject: RE: [RBASE-L] - edit using form child table where clause Dan Have you tried something like this EDIT using formname where parentNameColumn in (SELECT parentNameColumn FROM childTable where childColumn = value) Buddy From: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com> <rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>> On Behalf Of Dan Goldberg Sent: Tuesday, September 25, 2018 1:13 PM To: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com> Subject: [RBASE-L] - edit using form child table where clause Is there a way to put in the where clause to filter the child table? I can filter the parent table but the only way I think I can filter the child table is to use a view. Edit using formname where parentcolumn = value and childcolumn = value TIA Dan Goldberg -- 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.