Dear All
This program Coffee shop View example and I hope you example is true or not?
Dear All
This program Coffee shop View example and I hope you example is true or not?
What exactly are you asking?
thank you my dear teacher
Sorry My Dear Teacher possible illustrate more
and my dear teacher this example is true ?
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.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
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
Why use a listbox on the main form? Make IteamName textbox on the subform a combobox. Pick iteam from combobox.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
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-
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.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
@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.
Last edited by orange; 05-18-2022 at 09:16 AM.
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.
You can PM me if you need further help.
Good Reading https://docs.microsoft.com/en-gb/off...on-description
Someone who doesn't need help has resurrected an 8 year old thread.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
I did not notice the date of the thread. Must check closer in future.
You can PM me if you need further help.
Good Reading https://docs.microsoft.com/en-gb/off...on-description
Ditto Mike!! I didn't check either. Eagle-eyed Micron saves the day