Subject Re: creating unique key : usingprimair key and foreign key From Akshat Kapoor <akshat.kapoor@kapoorsons.in> Date Wed, 3 Feb 2021 22:27:08 +0530 Newsgroups dbase.getting-started Good Evening Dirk, > to collect information about all kind of articles and product i use the > following ( a main tabble and a child table) > >   by query >   the main tabel get a unique nr and main information, this info putted > aswell in the child table : > > the child table follows the main table as usual way.. > > the child table get his own unique nr as done by : see below: > > because of using the indexname of the child query, i can not vome back > to the main query, meaning the child query doesn't follow the main query > anymore .. > > once using the child query thers is no probleme to add or modify the info > > but creating a new record i have to restart the programm > > the watch is the index > > does someone have a hint I need some more info before I can give a confirmed suggestion. Are you using dbf tables or some other backend database system. If you are using level 7 dbf tables then you have a field type called autoincrement. Most of the backend database systems support this in some way or the other. If you use autoincrement then the unique number generation routine is not required. I think you should type help masterRowset in your command window and press enter. It should guide you how to display rows in child tables that are linked to the current row in main table. If I am not wrong then there is a German speaking group also. And there are some very good programmers who program in German. Have you tried posting there. Regards Akshat