Access help - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

Access help

Access help# Database - 数据库

m*12007-11-21 08:11

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*g2007-11-21 08:11

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