Thanks for the clarification.0
----- Original Message ----- From: "Sami Aaron" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Tuesday, November 09, 2004 12:13 PM Subject: [RBG7-L] - RE: Adding tables to form > Jan - > > Look at the sample database, Concomp, that came with your R:BASE > installation. There are several sample forms named OneToMany and > ManyToManyTabForm that would give you some ideas. Usually if the table > relationship is one-to-many then you place DBEdit fields at the top for the > one-side table, then add a scrolling region or dbgrid for the many-side > table and display the columns from the second table there. > > Sami > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jan > > Johansen > > Sent: Tuesday, November 09, 2004 1:34 PM > > To: RBG7-L Mailing List > > Subject: [RBG7-L] - RE: Adding tables to form > > > > > > Ok, > > > > Have 2 tables with same column name and type (does that link them). > > > > I wanted the form to display the data that exists in 2 tables and > > be able to > > edit those values. > > > > Jan > > > > > > ----- Original Message ----- > > From: "Sami Aaron" <[EMAIL PROTECTED]> > > To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> > > Sent: Tuesday, November 09, 2004 11:30 AM > > Subject: [RBG7-L] - RE: Adding tables to form > > > > > > > Jan - > > > > > > Adding a table to a form allows you to update more than one table on the > > > same form (like Invoice Headers and Invoice Details) - it is > > not for doing > > > lookups. > > > > > > Tables link by same-named columns with matching data. > > > > > > If you want a lookup, assign the dbEdit to the field in the form table, > > then > > > on the Object Properties, choose the Pop-Up Menus tab and create the > > lookup > > > to the second table for the pop-up. > > > > > > If this doesn't answer your question, post it again with details of what > > you > > > are trying to accomplish. > > > > > > Sami > > > > > > ------------------------------------------ > > > Sami Aaron > > > Software Management Specialists > > > 19312 W 63rd Terr > > > Shawnee KS 66218 > > > 913-915-1971 > > > mailto:[EMAIL PROTECTED] > > > www.softwaremgmt.com > > > > > > > -----Original Message----- > > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jan > > > > Johansen > > > > Sent: Tuesday, November 09, 2004 1:12 PM > > > > To: RBG7-L Mailing List > > > > Subject: [RBG7-L] - Adding tables to form > > > > > > > > > > > > What is the purpose of adding a table to a form? > > > > > > > > I thought it was to allow editing columns in more than one table. > > > > If so what establishes the link, because I have a DBEdit assigned to a > > > > column in the second table, but it sure isn't doing the lookup. > > > > > > > > Jan > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
