|
jedistev
Starting Member
Ireland
1 Posts |
 Posted - 01/18/2010 : 12:00:41
|
Hi
i have look book and Pdf, but cannot find right one, or maybe it don't have one right now
here is example
Create table Vacation.Employee_Details(
EmployeeID INTEGER PRIMARY KEY,
Name VARCHAR (215) ,
Task_Manager VARCHAR (215),
People_Manager VARCHAR (225),
Another VARCHAR (215)
Create table Vacation.request (
Request_ID integer PRIMARY KEY,
EmployeeRequestID integer references Vacation.Employee_Details(EmployeeID),
Name VARCHAR (15),
Date_start DATE,
Date_Finish DATE,
Total_Day VARCHAR (2),
Task_manger VARCHAR (50),
Comments VARCHAR (50),
Notes VARCHAR(50)
);
if i insert into Details on Table Employee Details like
Name Joe Blogg
EmplyeerequestID 5453
Task_manager Mr Men
and there is data on this which auto data gentrated without me put it on data on vacation
EmployeeID 5453
Name Joe Bloggs
Task_Manager Mr Bean
and it on database record,when open Vacation request i will find it there without me add on it but some are blank as well ,so the rest of it all i gotta type down blank
|
|
Enter Data in table and allow some data transfer
