Razzak, Because of my stolen laptop issue last year, I no longer have access to my previous SAT examples. I know that a great example lives in the SAT. I'm looking forward to seeing them again next Friday (3/29) in Portland, OR (not so shameless plug for training).
As soon as Bill mentioned the "Many to Many" setting in the form, I knew immediately that is what I had overlooked. Thanks all, Jan -----Original Message----- From: "A. Razzak Memon" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Wed, 20 Mar 2013 01:34:19 -0400 Subject: [RBASE-L] - Re: Table sample > At 02:34 PM 3/19/2013, Jan Johansen wrote: > > >Anyone have a good sample of a 4 tables that are properly PK'ed and > FK'ed > >together? > > > >I've got it too work with 2 tables but as soon as I add the 3rd table > it > >quits. I'm just overlooking something. > > Jan, > > In addition to Bill Downall's wonderful in-line tutorial ... > > Take a look at the sample "SalesTransactions" form included with 2013 > SAT > Sample Applications, that illustrates the PK/FK relationship between > five > (5) tables, including Customer, InvoiceHeader, InvoiceDetail, Employee, > and Contact. > > Folder...: C:\RBTI\2013_RBG95_SAT > Database.: RBU_SAT > Form.....: SalesTransactions > > Note: > > While in Form Designer, when adding FK tables for the master FK table, > make > sure to update the Table Relations to "Many-To-Many". > > Form Designer | Form Properties | Table Relations ... > > Very Best R:egards, > > Razzak. > > www.rbase.com > www.facebook.com/rbase > >
