DATABASE ACCESS

[IC1(SW/AW)]

I am trying to create a unique type of registration form for my job
upcoming Holiday Christmas
Party. There will be 60 tables for seatings with 10 people max at
table.

How can I write some codes to support this? I need to be able to see
the number of
people who are seating and any available seats at a given table. How
can I set my database
and pull the information to give what I want.

[Ray Costanzo [MVP]]

With a lookup table.

DDL:
CREATE TABLE Person (
PersonID smallint primary key identity,
PersonName varchar(100) NOT NULL DEFAULT ''
)

CREATE TABLE PartyTable (
PartyTableID tinyint primary key identity,
TableName varchar(20) NOT NULL DEFAULT ''
)
CREATE TABLE PTLookup (
PersonID smallint foreign key references Person(PersonID ),
PartyTableID tinyint foreign key references PartyTable(Part yTableID)
)
GO
SET IDENTITY_INSERT PartyTable ON
DECLARE @i tinyint; SET @i = 1
WHILE @i < 11
BEGIN
INSERT INTO PartyTable (
PartyTableID, TableName
) VALUES (
@i, 'Table ' + CAST(@i as char)
)
SET @i=@i+1
END


DIAGRAM:

Table:
PartyTableID (PK)--.
PartyTableName `.
\ PTLookup:
`-----PartyTableID (FK)
,--------PersonID (FK)
/
PersonID (PK)-----'
PersonName

QUERIES:
Find people sitting at a specified table:

SELECT PersonName FROM Person
INNER JOIN PTLookup
ON Person.PersonID = PTLookup.Person ID
INNER JOIN PartyTable
ON PTLookup.PartyT ableID = PartyTable.Part yTableID
WHERE
PartyTable.Part yTableID = 3
Get a count at each table:
SELECT
PartyTable.Tabl eName, COUNT(PTLookup. PersonID)
FROM
PartyTable INNER JOIN PTLookup
ON PartyTable.Part yTableID = PTLookup.PartyT ableID
GROUP BY
PartyTable.Tabl eName
Ray at work


"IC1(SW/AW)" <sc******@gmail .comwrote in message
news:11******** *************@i 42g2000cwa.goog legroups.com...

>I am trying to create a unique type of registration form for my job
upcoming Holiday Christmas
Party. There will be 60 tables for seatings with 10 people max at
table.

How can I write some codes to support this? I need to be able to see
the number of
people who are seating and any available seats at a given table. How
can I set my database
and pull the information to give what I want.

[Bob Barrows [MVP]]

IC1(SW/AW) wrote:

I am trying to create a unique type of registration form for my job
upcoming Holiday Christmas
Party. There will be 60 tables for seatings with 10 people max at
table.

How can I write some codes to support this? I need to be able to see
the number of
people who are seating and any available seats at a given table. How
can I set my database
and pull the information to give what I want.

If Ray's DDL generates errors when you try it, you should tell us what
database you are using. He provided Transact-SQL code for SQL Server. it
won't work for other types of databases.

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Slim]

"IC1(SW/AW)" <sc******@gmail .comwrote in message
news:11******** *************@i 42g2000cwa.goog legroups.com...

>I am trying to create a unique type of registration form for my job
upcoming Holiday Christmas
Party. There will be 60 tables for seatings with 10 people max at
table.

Thanks but I'm going away at Christmas.

How can I write some codes to support this? I need to be able to see
the number of
people who are seating and any available seats at a given table. How
can I set my database
and pull the information to give what I want.

[IC1(SW/AW)]

I will be using microsoft access as my database. Will these code work
with access.

Bob Barrows [MVP] wrote:

IC1(SW/AW) wrote:

I am trying to create a unique type of registration form for my job
upcoming Holiday Christmas
Party. There will be 60 tables for seatings with 10 people max at
table.

How can I write some codes to support this? I need to be able to see
the number of
people who are seating and any available seats at a given table. How
can I set my database
and pull the information to give what I want.

If Ray's DDL generates errors when you try it, you should tell us what
database you are using. He provided Transact-SQL code for SQL Server. it
won't work for other types of databases.

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Ray Costanzo [MVP]]

No, it won't work in Access, but you can manually create the tables in the
same way. You'll have to write your queries a little different, I believe.
It seems Jet likes to use no fewer than 18,000 parentheses in any query that
uses more than one table. ;]

If you struggle with writing the queries in Jet format, post back.

Ray at work
"IC1(SW/AW)" <sc******@gmail .comwrote in message
news:11******** **************@ m73g2000cwd.goo glegroups.com.. .

>
I will be using microsoft access as my database. Will these code work
with access.

Bob Barrows [MVP] wrote:

>IC1(SW/AW) wrote:

I am trying to create a unique type of registration form for my job
upcoming Holiday Christmas
Party. There will be 60 tables for seatings with 10 people max at
table.

How can I write some codes to support this? I need to be able to see
the number of
people who are seating and any available seats at a given table. How
can I set my database
and pull the information to give what I want.

If Ray's DDL generates errors when you try it, you should tell us what
database you are using. He provided Transact-SQL code for SQL Server. it
won't work for other types of databases.

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[IC1(SW/AW)]

I tried the table setup in ACCESS and I couldn't get it to work. Need
Help......:>
Ray Costanzo [MVP] wrote:

No, it won't work in Access, but you can manually create the tables in the
same way. You'll have to write your queries a little different, I believe.
It seems Jet likes to use no fewer than 18,000 parentheses in any query that
uses more than one table. ;]

If you struggle with writing the queries in Jet format, post back.

Ray at work
"IC1(SW/AW)" <sc******@gmail .comwrote in message
news:11******** **************@ m73g2000cwd.goo glegroups.com.. .

I will be using microsoft access as my database. Will these code work
with access.

Bob Barrows [MVP] wrote:

IC1(SW/AW) wrote:
I am trying to create a unique type of registration form for my job
upcoming Holiday Christmas
Party. There will be 60 tables for seatings with 10 people max at
table.

How can I write some codes to support this? I need to be able to see
the number of
people who are seating and any available seats at a given table. How
can I set my database
and pull the information to give what I want.

If Ray's DDL generates errors when you try it, you should tell us what
database you are using. He provided Transact-SQL code for SQL Server. it
won't work for other types of databases.

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[IC1(SW/AW)]

Since I'm working on the company intranet. Could I just design
everything in access and allow the user to fill a form via access?


IC1(SW/AW) wrote:

I tried the table setup in ACCESS and I couldn't get it to work. Need
Help......:>
Ray Costanzo [MVP] wrote:

No, it won't work in Access, but you can manually create the tables in the
same way. You'll have to write your queries a little different, I believe.
It seems Jet likes to use no fewer than 18,000 parentheses in any query that
uses more than one table. ;]

If you struggle with writing the queries in Jet format, post back.

Ray at work
"IC1(SW/AW)" <sc******@gmail .comwrote in message
news:11******** **************@ m73g2000cwd.goo glegroups.com.. .

>
>
>
I will be using microsoft access as my database. Will these code work
with access.
>
Bob Barrows [MVP] wrote:
>IC1(SW/AW) wrote:
I am trying to create a unique type of registration form for my job
upcoming Holiday Christmas
Party. There will be 60 tables for seatings with 10 people max at
table.
>
How can I write some codes to support this? I need to be able to see
the number of
people who are seating and any available seats at a given table. How
can I set my database
and pull the information to give what I want.
>>
>If Ray's DDL generates errors when you try it, you should tell us what
>database you are using. He provided Transact-SQL code for SQL Server. it
>won't work for other types of databases.
>>
>--
>Microsoft MVP -- ASP/ASP.NET
>Please reply to the newsgroup. The email account listed in my From
>header is my spam trap, so I don't check it very often. You will get a
>quicker response by posting to the newsgroup.
>

[Ray Costanzo [MVP]]

Can you be a little more specific? Need help with what?

Ray at work

"IC1(SW/AW)" <sc******@gmail .comwrote in message
news:11******** **************@ f16g2000cwb.goo glegroups.com.. .

>I tried the table setup in ACCESS and I couldn't get it to work. Need
Help......:>
Ray Costanzo [MVP] wrote:

>No, it won't work in Access, but you can manually create the tables in
the
same way. You'll have to write your queries a little different, I
believe.
It seems Jet likes to use no fewer than 18,000 parentheses in any query
that
uses more than one table. ;]

If you struggle with writing the queries in Jet format, post back.

Ray at work
"IC1(SW/AW)" <sc******@gmail .comwrote in message
news:11******* *************** @m73g2000cwd.go oglegroups.com. ..

>
I will be using microsoft access as my database. Will these code work
with access.

Bob Barrows [MVP] wrote:
IC1(SW/AW) wrote:
I am trying to create a unique type of registration form for my job
upcoming Holiday Christmas
Party. There will be 60 tables for seatings with 10 people max at
table.

How can I write some codes to support this? I need to be able to see
the number of
people who are seating and any available seats at a given table. How
can I set my database
and pull the information to give what I want.

If Ray's DDL generates errors when you try it, you should tell us what
database you are using. He provided Transact-SQL code for SQL Server.
it
won't work for other types of databases.

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[IC1(SW/AW)]

Ok, I am trying to develop a web registration form for my Command
Military Christmas Party.
There will be 60 seating tables each table handling a max seating of
10 personnel at the party. The form needs to be able interact with a
database that will permit the following capabilities: To register for
seating, To see current names of people who have already registered(
this will let them know where their buddies are siting), annd allot a
certain number of seats for registering per table(10). Is this
possible to write codes to do this?
Should I just do this in ACCESS and have everybody to register via our
intranet? What is the easy and quickest way to do this? I got 2wks to
knock this out. Please help..

Ray Costanzo [MVP] wrote:

Can you be a little more specific? Need help with what?

Ray at work

"IC1(SW/AW)" <sc******@gmail .comwrote in message
news:11******** **************@ f16g2000cwb.goo glegroups.com.. .

I tried the table setup in ACCESS and I couldn't get it to work. Need
Help......:>
Ray Costanzo [MVP] wrote:

No, it won't work in Access, but you can manually create the tables in
the
same way. You'll have to write your queries a little different, I
believe.
It seems Jet likes to use no fewer than 18,000 parentheses in any query
that
uses more than one table. ;]

If you struggle with writing the queries in Jet format, post back.

Ray at work
"IC1(SW/AW)" <sc******@gmail .comwrote in message
news:11******** **************@ m73g2000cwd.goo glegroups.com.. .

I will be using microsoft access as my database. Will these code work
with access.

Bob Barrows [MVP] wrote:
IC1(SW/AW) wrote:
I am trying to create a unique type of registration form for my job
upcoming Holiday Christmas
Party. There will be 60 tables for seatings with 10 people max at
table.

How can I write some codes to support this? I need to be able to see
the number of
people who are seating and any available seats at a given table. How
can I set my database
and pull the information to give what I want.

If Ray's DDL generates errors when you try it, you should tell us what
database you are using. He provided Transact-SQL code for SQL Server.
it
won't work for other types of databases.

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.