SQL Select with Binary Link

[Chris McConnell]

OK so here is a total process if I want to use binary pointerS

 

1)       I insert a new record into the customer table

2)       I retreive the last insert record id for the customer table
(cust.recId)

3)       I insert a phone number record

4)       I retreive the last insert record id for the phone table (ph.recId)

5)       I then insert into link link_name VALUES( cust.recId , ph.recId)

 

 

 

 

Yours Truly,

Christopher L McConnell

chris at mc-data.com