> how do I draw a self-referential relation? You cannot make a single field both the primary and foreign keys of a relation. You must choose two different fields. For example, you can make [Table_1]Field1 related to [Table_1]field2 Reminder: the fields must be compatible with each other as you would not be able to relate a longint field to an alpha field...
> how do I modify the system tables? You cannot directly modify the system tables. The system tables represent the underlying structure, so to change the system tables you would change the structure and then the system table will automatically reflect that change. -Tim ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************