Hi all
lets say i have 3 tables ,
tblEmployee which consisit for
EmployeeCode int primary key
EmpoyeeName nvarchar (100)
Image image
Sex nvarchar(10)
Bloodgroup nvarchar (10)
DateOfBirth date
2- tblAddressDetials which consist of :
AddressID int (primary key)
EmployeeCode int ( this is FK to connected to tblEmployee)
Address nvarchar (100)
PhoneNo nvarchar(20)
emailAddress varchar(20)
3- tblEquipments consist of :
EquipmentsID int (Primary key)
EmployeeCode int (this is forign key to connected to tblEmployee)
EquipmentName nvarchar(100)
EquipmentSerialNo varchar (100)
Status varchar(10)
there is relation between these three table one to many ,
now if i want to have 3 tabs for each table to enter information for the same employee how i do ...
Go to the complete details ...