Hi all ,
lets say i have 2 relational tables (one to many )
tblEmployee
EmployeeCode int PK Name nvarchar 50) JobTitle nvarchar (50) Salary
tblEquipments
EmployeeCode int FK EquipmentID int PK EquipmentName nvarchar (50) EquipmentSerialNo nvarchar (50)
now , how to Design a form which enable your to insert more than one Equipments for one employee?
i did this in Microsoft Access by creating a child From in data sheet mode which enabled me to add more than one equipment for one employee in one shot.
i hope you understand what i mean
many thanks for the help
Go to the complete details ...