thank you Razzak, Sami & David - I changed the setting to many to many and
all the below problems disappeared - The more you work with a new product,
the more you have to learn - and this list is a wonderful source of
information.
thank you again for your help and patience
J
At 07:11 AM 2/10/2005, you wrote:
At 01:56 AM 2/10/2005, J. Blaustein wrote:
under v7.1 latest download all rows appears between
level 2 and level 3 whether related or not if they
have a common relationship with level 1
Has any one experience the above?
Is there something I am doing wrong regards to v7.1
J,
01. What is the "Table Relation" set to?
Form Designer | Form Properties | Table Relations
Options:
. One to Many
. Many to Many
02. What is the sequence of tables in Form Designer
Form Designer | Main Menu | Tables | Add/Remove Tables
For a sample form with Master/Slave relationship, take
a look at the SalesTransactions and SalesTransactions2
forms related to the following tables:
Database: RRBYW9
Forms: SalesTransactions, SalesTransactions2
Associated Tables:
. Customer
. InvoiceHeader
. InvoiceDetail
. Employee
. Contact
Table Relation: Many to Many
Application:
RRBYW9 | Main Menu | Sales | View Customer and Sales Transactions
Hope that helps!
Very Best R:egards,
Razzak.
