Multiple rows

[Charles]

Hi all,

How do I create multiple rows per record?
For example:

ProjectId Student names Comments
homework1 Charles Completed
John Completed
liza Not completed
Homework2 Maria Completed
Amy Not Completed

thank you for your help

 

[Rick Brandt]

Hi all,

How do I create multiple rows per record?
For example:

ProjectId Student names Comments
homework1 Charles Completed
John Completed
liza Not completed
Homework2 Maria Completed
Amy Not Completed

You don't. You create a second table and create a one-to-many relationship
to it from the original.

 

[John Vinson]

Hi all,

How do I create multiple rows per record?

By storing your data in two tables, in a one to many relationship.

Look up "Normalization" in the online help, or at Microsoft's website
http://support.microsoft.com.