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