Project translated automatically. Log in or register, to view the original There is a geneological database in Access.It has tables tblIR - a list of people with the number of marriage in which they are born, tblMR - a table of marriage with the ind numbers of husband and wife, and tblCR - the connection of children and parents through marriage in which children are born (the fields tblCR.IDMR and tblIR.IDMRParents) Task 1: Remember all the ancestors of a particular person.For this, the number form (IDIR) is entered and for this number all ancestors are marked in the selected TagN field consistently (you can make a cycle in the macro until the value of tblIR.IDMRParents is not equal to 0).At the same time, in each generation you need to note in the TagN field the tblIR tables of the husband, wife, and then go through him and her ancestors consistently as long as they are in the base (maximum to 25 generations).Task 2: Remember all the descendants of a particular person.Also in the form is entered the value IDIR (predecessors), the field number in which to mark the descendants (TagN), then their descendants are marked by the macros in the fields Tag.You can find descendants by coincidence of tblIR.IDIR and tblMR.IDIRHusb or tblMR.IDIRWife, and then all descendants by number tblMR.MRID (one number tblMR usually corresponds to several children in the tblCR table).In the form you need to make a button to turn all the fields Tag or one of them to clean the fields before the new macro is performed.I can't send the base: it's very large and contains personal data of people.Therefore, I propose to write only macros according to the specified specifications, I will look at them and test them.