General information
Title:
Identity columns and committing table buffered views...
Ok, simple...
I have 10 new recs in a view (vHeader) and I have 100 new recs on child view (vDetail). Both views are table buffered and I am using an Identity column for the pkey of the header table. How would I go about getting the newly assigned pkey values to use as the fkey values in the detail table? @@Identity and the like won't do much for me unless I want to run through my detail after header is committed, etc. Should I simple put a trigger on insert of detail to get value for fkey from parent? In this case I can do that - but what about when key data is not cascaded to detail?
Thanks.
Mark
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only