J
Jon Vaughan
I have a hierachical dataset brought back from a sql server stored procedure
with a design as follows :
StaffID
<Staff Columns>
AddressID
<Address Columns>
StaffID_FK
PhoneID
<Phone Columns>
AddressID_FK
Im using a disconnected architecture, so when I recieve the dataset , I
remap the the relationship (is there no way to get this relationship from
sql server - see's silly remapping). What im now looking to do is to
duplicate a staff members data , if I copied a row from the Staff table will
all the related data also be duplicated ? and if it wont whats the best way
to achieve this result ?
Jon
with a design as follows :
StaffID
<Staff Columns>
AddressID
<Address Columns>
StaffID_FK
PhoneID
<Phone Columns>
AddressID_FK
Im using a disconnected architecture, so when I recieve the dataset , I
remap the the relationship (is there no way to get this relationship from
sql server - see's silly remapping). What im now looking to do is to
duplicate a staff members data , if I copied a row from the Staff table will
all the related data also be duplicated ? and if it wont whats the best way
to achieve this result ?
Jon