Hiding certain records in Access

[SeanHughes1515]

Hello,
I am a college student and i have created a database based on a pizza
delivery service.
One of the criteria requires me to suspend certain customers on a
customer form, who will no longer appear on my order form which
effectively prevents them from ordering. Not sure how to do this, can
anyone help?

 

[SeanHughes1515]

Hello,
I am a college student and i have created a database based on a pizza
delivery service.
One of the criteria requires me to suspend certain customers on a
customer form, who will no longer appear on my order form which
effectively prevents them from ordering. Not sure how to do this, can
anyone help?

Oh sorry, i just created an SQL statement and i got it

 

[Klatuu]

Sean,
I see you have it figured out, but having written a food home delivery
system about 20 years ago, I have a couple of suggestions.

In the real world, if a user doesn't see a customer in the list, he may try
to add the customer not knowing the customer is blocked. In your routine for
adding a customer, when the user enters the field used to locate a customer
(usually by phone number), you need to do a DLookup to see if the customer
exists, and if blocked, notify the user so he can take appropriate action.

Also, if you use phone number, be aware multiple phone numbers can be
associated with one address. You need to have a cross reference table that
lists all the phone numbers for that addess. You also need to block by phone
number rather than address, because an address could be an office building
and you don't want to block the entire building.

You will find that most such systems use phone number because entering
addresses is not that accurate. One user may put in 123 Main and another 123
Main St. or 123 Maine, or 123 Mane. See the problem?

And be sure you are allowing for different toppings on pizza halfs.

Good luck.