Hello Lynn,
This is what it says.........
Template Not Found.
The template you are trying to access was not found.

Rashid
"Lynn Trapp" wrote in message
...
The link isn't actually broken, but has wrapped on to multiple lines. You
may have to select each line and paste them successively into your
browser.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"Rashid Khan" wrote in message
...
Hi Ashley,
Thanks for your reply..But the link is broken....Can u suggest
something
else?

"Ashley" wrote in message
...
Try this link. It is an order template. Ashley
http://office.microsoft.com/templates/preview.aspx?
AssetID=TC010185481033&CTT=1&Origin=EC790000701033 &QueryID=
k-u5d42vV&Query=access&Scope=TC
-----Original Message-----
Further to my previous post. I am using Access 2002..
"Rashid Khan" wrote in message
...
Hello All Experts,


I have been after this for quiet some time now :-(. I
want to design a
database for a Restaurant. As I am a newbie on the
learning curve I need
a
helping hand to guide me thru.



I have the following Tables.

RI = Referential Integrity, CU = Cascade Update, CD =
Cascade Delete

1 to M = One-to-Many Relationship



Customer

-CustomerID (PK)

-other details as name, surname etc.

- StaffID (FK)

- OrderID (FK)



Table

- TableID (PK)

- TableDetails



Staff

-StaffID (PK)

-StaffName, DateofHire, etc

-StaffRoleID (FK)



StaffRole

-StaffRoleID (PK)

-StaffRoleDescription



Order

- OrderID (PK)

- OrderDate

- OrderTime

- CustomerID(FK)

- StaffRoleID(FK) (1 to M )

- MenuItemID (FK)

- TableID (FK)



OrderMenuItem

- OrderMenuItemID (PK)

- OrderMenuItemQuantity



MenuItem

- MenuItemID (PK)

- MenuItemDescription

- MenuItemPrice

- MenuItemQuantity

- CategoryID (FK) (1 to M with RI)

- OrderID (FK) (1 to M with RI, CU, CD)



Categories

- CategoryID (PK)

- CategoryDescription (eg Starters, Desserts, Cold
Drinks etc. etc.)

- CustomerID (FK) (1 to M)



Payments

- PaymentID (PK)

- OrderID (FK) (1 to M with RI, CU and CD)

- PaymentAmount

- PaymentDate

- PaymentMethodID (FK) (1 to M)



PaymentMethod

- PaymentMethodID (PK)

- PaymentMethod (eg Credit Card, Cash, Check etc. )



OrderDetails

- OrderDetaisID (PK)

- OrderID (FK) (1 to M) RI, CU, CD

- MenuItemID (FK) (1 to M)

- Quantity

- UnitPrice

- Discount



This is how far I have got.

Can somebody guide me in restructuring my design. I
must have missed
several basics. Pardon me for my ignorance.



Basically I want to design a Restaurant database where
the Customer walks
in
and places an Order from a Category (subdivided in
MenuItems) which is
executed by a Staff. After the completion of the order
the Bill will be
generated.



Any help or suggestions would be very much appreciated.



Rashid Khan














.