m******1 发帖数: 1 | 1 I need to create a database for our 6 to 8 people to tracking time and cost
spending on each project.
I have created 3 major tables.
One is staff table. Which has staff id( primary key), name, rate…
One is project table. Which has projected(primary key), name….
One is StaffStudy table, which has staffID and projected joined as primary
key…
I have another table which will store StaffID, ProjectID, Date and hours.
Which has StaffID, ProjectID, Date joined as primary key.
I need to create a form th | B*****g 发帖数: 34098 | 2 不太清楚你再问什么?
难道不是 SELECT ProjectID FROM StaffStudy WHERE staffID = :SELECT ?
cost
if
are
【在 m******1 的大作中提到】 : I need to create a database for our 6 to 8 people to tracking time and cost : spending on each project. : I have created 3 major tables. : One is staff table. Which has staff id( primary key), name, rate… : One is project table. Which has projected(primary key), name…. : One is StaffStudy table, which has staffID and projected joined as primary : key… : I have another table which will store StaffID, ProjectID, Date and hours. : Which has StaffID, ProjectID, Date joined as primary key. : I need to create a form th
|
|