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 > > > > > > > > > > > > > > > > > > > >
