1 to many 1

rmill · Feb 14, 2003

In my view window of 2.6 my 1ToMany button is not available? How Can I use it please?

rgbean · Feb 14, 2003

First, set up a relationship between two tables. e.g.

Code:

SELECT 1
USE cust.dbf
SELECT 2
USE detail.dbf
SET ORDER TO TAG Acct_no OF detail.cdx
SELECT 1
SET RELATION TO acct_no INTO Detail ADDITIVE

While I wouldn't exactly code it this way, this is what was echoed to my Command Window using the View Window.

Now chosing 1-To-Many will generate:

Code:

SET SKIP TO Detail

Rick

Rick