>>>I made a Form in wick i use a relation to another table
>>>I used a combo box, the result of the click of the mouse
>>>in the combo box goes to a register in other table but when i push the new record botton an error occurs:
>>>APPEND BLANK
>>>violation in the register
>>>why tha error?
>>
>>If you have a candidate or Primary (unique) Index then you may already have a blank field in that index. This is not allowed. Look for a blank field in your indexed field. You can also put trapping in to make sure this does not occur the first time.
>>
>>HTH,
>>Tom
>
>Also, if the child table does not already have a corresponding record to the parent, Fox will create a 'phantom' record in the child which WILL interfere with adding a blank record to that child. I got bit severely by that. My eventual fix was to INSERT into the child with at least the key field value.
I also had trouble with APPEND BLANK with related child table if it was the first new record in both the parent and child table. I found several solutions. Break the relation and then Append Blank then reset the relation, use insert with the key field value as suggested (but this does not allow tablerevert() to delete the record), and use a form (with text boxes only) to add the data in the child record. if you try to Append Blank and use a grid for the first new child record it does not work consistenty in the correct manner.
Jim
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement