Microsoft KB Archive/119694

{| = How to Obtain Name of Child Database Alias in a Relation =
 * width="100%"|

ID: Q119694

The information in this article applies to:


 * Microsoft FoxPro for MS-DOS, version 2.5x, 2.6
 * Microsoft FoxPro for Windows, versions 2.5x, 2.6
 * Microsoft FoxPro for Macintosh, versions 2.5b, 2.5c

SUMMARY
Sometimes it is useful to programmatically derive the name of a child database that is related to the current (parent) database. The program below demonstrates how to do this.

MORE INFORMATION
The following program demonstrates how to use the SET function to determine the name of the child database:

SELECT 1 USE customer IN 1 ORDER cno USE invoices IN 2 ORDER cno SET RELATION TO cno INTO invoices * The following line will place the alias "INVOICES" * in the memory variable m.child. m.child=RIGHT(SET("RELATION"),LEN(SET("RELATION"))- ;          RAT(" ",SET("RELATION"))) NOTE: Instead of SET, you could use the TARGET function, which returns the alias name of the nth child database related to a specified alias. Additional reference words: FoxMac FoxDos FoxWin 2.60 2.50 2.50a 2.50b 2.50c KBCategory: kbenv kbprg kbcode KBSubcategory: FxenvMemory
 * }