When you have a linking column and also other non-linking columns, and you wish to slave table2 to table1 in a single form, create a view that renames all common columns except the linking one for one of the tables. Make sure this is a single table view. Now use the view in your form, and the slave table will appear correctly. As it is a single table view, it is editable.
Bill Niehaus <[EMAIL PROTECTED]> wrote:The tables have more than one column in common and may not be identical between the two tables. Bill N. >>> [EMAIL PROTECTED] 8/9/2004 6:45:41 AM >>> At 10:34 PM 8/8/2004 -0500, Bill Niehaus wrote: >I have never used a single form for editing data from two tables with a >common column. I looked through some examples (e.g. OneToManyDBGrid in >RRBYW) but have not been able to get the second table to show up. > >Are there some general procedures that would help set up such a form? Bill, 01. Do both tables have more than one matching column(s)? 02. If there are more than one matching column, and if the column values are different, the slave table data is not going to show up. 03. For more examples, take a look a the following forms in RRBYW8: Database: RRBYW8 Forms: CustContAndSales CustomerContacts Products SalesTransactions Hope that helps! Very Best R:egards, Razzak. ===== Albert Berry Management Consultant RR2 - 1252 Ponderosa Drive Sparwood BC, V0B 2G2 Canada (250) 425-5806 (250) 425-7259 (708) 575-3952 (fax) [EMAIL PROTECTED]
