David, Ben : >> Create a view which does a Cartesian join of your address table with the Numbers table. CREATE VIEW ManyLabels AS SELECT colame1, colname2, .... + FROM Addresses, Numbers Notice there is no join clause. This view returns 1000 copies of every row in your address table. Create a label definition on that view. Then you can say LBLPRINT MultiLabels WHERE AddressID = .vAddressID AND NumberID between 1 and 30 <<
Congratulations for this very simple and very clever idea !!! This list is definitively GREAT .... J.M. GRATIAS, Logimatique ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
