Staff--(1,M)---Protocol

USE [SCRIDB]

GO

/****** Object: Table [dbo].[Staff] Script Date: 08/28/2010 15:54:14 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[Staff](

[StaffID] [int] IDENTITY(1,1) NOT NULL,

[FirstName] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS...

If you're doing this in Access, just use the crosstab query wizard... 🙂