There are two things you need to do to make a multi-table form work properly:
1. Under the Form Properties, click on the Table Relations tab and click Many-to-Many 2. Be sure that the linking columns in all the tables on the form are named with the same column names and that there are NO columns with the same name that are NOT really linking columns (For example, if you are linking Customers to SalesPeople, if each of those tables has a column named ZipCode, you would have a problem and would need to rename one of them to CustZipCode or something like that.) ____________________________ Sami Aaron Software Management Specialists 913-915-1971 [EMAIL PROTECTED] From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, June 30, 2008 8:28 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Choose command with CHKBOX n option I had problems creating automatically ( wizard generated form ) with master detail relationship when there are two detail tables. Is two or more detail tables supported ? Thanks
