By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,587 Members | 1,076 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,587 IT Pros & Developers. It's quick & easy.

Help Needed on Creating Database

P: 2
Hi,

The title seems vague, but i could not think of anything more descriptive. I am creating a database and i am a bit stuck. I have started to create a database for pupils in a school.

I have created the tables, includes:

Pupil (containing pupil information, class etc)
Homework (containing homework information)
Complete (table linking the above, and a check box to determine if a pupil has completed a homework or not)

The problem i have is that when i enter the details for the homework, i dont know how to force this information into the pupils data. Basically, i want to enter the homework data, then perform an action that automatically assigns this homework to the pupils records, instead of me doing it one by one for each pupil on the main form (main form has pupil information and a sub form that has the tblcomplete date with the check box).

Any help would be appreciated. Thanks in Advance
Ish
Mar 20 '07 #1
Share this Question
Share on Google+
3 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
Hi Ish

Can you post the metadata for these tables.

Here is an example of how to post table MetaData :
Table Name=tblBookings
Expand|Select|Wrap|Line Numbers
  1. Field; Type; IndexInfo
  2. Field; Type; IndexInfo
  3. StudentID; Autonumber; PK
  4. Family; String; FK
  5. Name; String
  6. University; String; FK
  7. Mark; Numeric
  8. LastAttendance; Date/Time
Mar 21 '07 #2

P: 2
Hi, thanks ive sorted the problem, i just needed to create another table and link that in. Thanks for the reply.

ish


Hi Ish

Can you post the metadata for these tables.

Here is an example of how to post table MetaData :
Table Name=tblBookings
Expand|Select|Wrap|Line Numbers
  1. Field; Type; IndexInfo
  2. Field; Type; IndexInfo
  3. StudentID; Autonumber; PK
  4. Family; String; FK
  5. Name; String
  6. University; String; FK
  7. Mark; Numeric
  8. LastAttendance; Date/Time
Mar 22 '07 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
No problem.
Mar 23 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.