patient prescription record
this pic 1 is related data from other table
this pic 2 is from same table
this pic 3 data from other table
this pic 4 from same table
now i am duplicating pic is below
question is pic 1 & pic 4 data is getting copied when duplicated why not pic 2 and pic 3 is my question hope i am clear this tym
if i made mistake in making relationship the data wont appear right , so i am not understanding why ??
duplicating copies data from same table without problem then why not pic 2 isnt copied as it is from same table ??
sir it has big sense in reality , i am duplicating because some drugs need to be continued some to be changed for being easier on me i thought of duplicating to make neccesary changes to new prescription