Coffee Shop Database

[AzizSader]

Dear All


This program Coffee shop View example and I hope you example is true or not?

[burrina]

What exactly are you asking?

[AzizSader]

thank you my dear teacher
Sorry My Dear Teacher possible illustrate more
and my dear teacher this example is true ?

[June7]

I think you have right idea.

Probably need a Food table that can be the source of items for a combobox in the FoodTable subform. Surely will have more than 3 food items.

There is no reason for users to see the autonumber fields on forms.

[AzizSader]

Very Very Thank You My Dear Teacher
My Dear Teacher
In the model when the main pressure on IteamName in Item List added IteamName and Price to form the sub-
For example, in the list of any Iteam when pressure for Pizza Pizza is added to the subform

[June7]

Why use a listbox on the main form? Make IteamName textbox on the subform a combobox. Pick iteam from combobox.

[AzizSader]

thank you my dear teacher but my dear teacher
The program of work is required in this design
In the model when the main pressure on IteamName in Item List added IteamName and Price to form the sub-

[June7]

Sorry, language barrier is interfering. What do you mean by 'pressure' - mouse click? Why do something the hard way? What you are requesting will require code (I use only VBA). The combobox in subform would not require code to save the IteamName.

[orange]

@AzizSader,

There is an issue with communicating/understanding your post.
Do you have a specific question? Please describe the Coffee shop business in simple terms.
If English is not your language, then write your question in your native language and use Google Translate to get the English translation. Paste that translated text to your post.

Here is a partial data model for CoffeeShop that may give you some insight on your project.

From Google:

What happens in a coffee shop?



A coffeehouse, coffee shop, or café is an establishment that primarily serves coffee of various types, e.g. espresso, latte, and cappuccino. Some coffeehouses may serve cold drinks, such as iced coffee, iced tea, and other non-caffeinated beverages. In continental Europe, cafés serve alcoholic drinks.

[mike60smart]

Hi

The attached will get you started.

Look at the Relationship Diagram.
Study the naming of tables and fields.
As June suggested the selection of the Items would be on the Subform.

[Micron]

Someone who doesn't need help has resurrected an 8 year old thread.

[mike60smart]

I did not notice the date of the thread. Must check closer in future.

[orange]

Ditto Mike!! I didn't check either. Eagle-eyed Micron saves the day