S shekar.kr New Member Dec 3, 2010 #1 How to insert data into two tables along with the relationships, and display from that two tables. Table 1: S.no Name Table 2: R.no S.no Class Marks Here S.no is common in two bales.
How to insert data into two tables along with the relationships, and display from that two tables. Table 1: S.no Name Table 2: R.no S.no Class Marks Here S.no is common in two bales.
jdpjamesp ProgressTalk.com Moderator Staff member Dec 3, 2010 #2 Code: create table1. assign table1.sno = next-value(sequence) table2.name = "fred". create table 2. assign table2.sno = table1.sno etc... Or am I missing something?
Code: create table1. assign table1.sno = next-value(sequence) table2.name = "fred". create table 2. assign table2.sno = table1.sno etc... Or am I missing something?
