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
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
