Hello.
I have to model a stable, and so stallions, which belong to an owner at a date t etc ... so far so good. Except that the person responsible imposes that only Stallions - not mare, why? I know it's weird, but do not ask me why, this is so - have to be modeled, and so have only one father, and this father is in the stable, he does not want to buy others stallions, and does not do not want to register the mares. He wants to have statistics on the stallions, to see their performances at the level of the races, their health, their diseases etc especially to trace them in relation to their father only. So level modeling is little problem, since a horse can only have one and only one father, and a stallion can be the father of 0 to several stallions -only the males will be retained. So far we agree, there is nothing exceptional. Even a first year student is able to modeling it. But it is in the implementation of Microsoft Access that begins the problem. I can not enter a first record, since logically Microsoft Access asks me the father of the first one that does not exist. Questions: How to do it? What to do ? And where to start? I do not have the right to change the relation between tables of the stallion, which must imperatively remain: one-to-many. In fact it is the good old modeling of a reflexive table and its constraints of integrity and foreign keys.
Error Message gives : You can not add or change record because record is required in table. I think it is classical error.
Thx for any help.
I have to model a stable, and so stallions, which belong to an owner at a date t etc ... so far so good. Except that the person responsible imposes that only Stallions - not mare, why? I know it's weird, but do not ask me why, this is so - have to be modeled, and so have only one father, and this father is in the stable, he does not want to buy others stallions, and does not do not want to register the mares. He wants to have statistics on the stallions, to see their performances at the level of the races, their health, their diseases etc especially to trace them in relation to their father only. So level modeling is little problem, since a horse can only have one and only one father, and a stallion can be the father of 0 to several stallions -only the males will be retained. So far we agree, there is nothing exceptional. Even a first year student is able to modeling it. But it is in the implementation of Microsoft Access that begins the problem. I can not enter a first record, since logically Microsoft Access asks me the father of the first one that does not exist. Questions: How to do it? What to do ? And where to start? I do not have the right to change the relation between tables of the stallion, which must imperatively remain: one-to-many. In fact it is the good old modeling of a reflexive table and its constraints of integrity and foreign keys.
Error Message gives : You can not add or change record because record is required in table. I think it is classical error.
Thx for any help.