Search results

i figured out the problem: i had the RecordLocks property set to All on my subform, which conflicted with the same data on the main form that wasn't locked at all. gemma: any thoughts on how i could draw such a tree? i would keep it very limited, only the current record, its parents, direct...

oh, and about the rules and such, i didn't even think of this stuff yet, but i'll be sure to add some constraints like this when i get it to work!

nanscombe: this is pretty much exactly what i want! strangely it doesn't work on my form this way though, upon building the form i get the following error: "Table is opened exclusively by another user or opened with the help of user interface and cannot be manipulated through programming." (more...

the parents are also found in the main form yes, and i would like the subform to be a form. the problem with a drop down menu is that there is no single required field. for example, names are not always given to all offspring. if i instead use the primary key id (autonumber) to identify the...

hello, for a breeding project i'm creating a database which holds all animals. i'm trying to make the parents selectable in a subform based on the same table as the main form - this doesn't work for whatever reason ("table is already opened exclusively by another user,..."). it can't just be...