>>When I refresh CA after tableupdate I still don't get PK in my CA, it remains empty.
>>
>>In other words, I add a new record to the parent table, I save the information and now I need to add a record to the child, but I keep receiving the message that I need to save the parent first (since my ID is still empty).
>
>OOOOO, that is the case. Then you need a way to get the parent ID Before you save the records in child CA.
>Add the parent record and add all child records you need. Then:
>BEGIN TRANSACION
>1. Save the record in Parent table
>2. Get the PK from parent
>3. REPLACE ALL Fk WITH Parent.Pk in Child
>4. Save Child Records
>END TRANSACTION
No, I decided against this already. After I add a new record to the parent, I need to save it first. I do save it, but after I do CursorRefresh I still do not get my ID in the CA alias. That's my problem. Since you now have all the source code, you may be able to see what my attempts are.
Thanks a million again for your generous help.
If it's not broken, fix it until it is.
My Blog