SQL7/VFP7

Front End (VFP) inserts a record in SQL table A and then pulls @@Identity to put pkey back in front-end cursor and for use in related child cursor fkeys. Table A though, has insert trigger that inserts multuiple rows into several other tables, thus @@Identity returns incorrect value for Table A record.

Question: Is there any call that will return the identity field value of the first (or main) inserted into table vs. the cacaded ones, or am I left with a different front end approach?

thanks,