Results 1 to 2 of 2
  1. #1
    JacobMontoya is offline Novice
    Windows 10 Access 2016
    Join Date
    Dec 2018
    Posts
    1

    Exclamation Create a table that lists items in different categories

    Hello everybody,
    I am doing a project that requires me to create a database for a catering company. I have the basic structure but I need to know how to create a table that can list the different types of food as follows: 3 categories (Entré, appetizers, desserts) each one with a group of items (Entré:chicken, steak,etc.). I am not sure if this is possible but I would like to do it in 1 table.


    Here is the structure of my database to make things clearer.
    Click image for larger version. 

Name:	Captura de pantalla (1).jpg 
Views:	9 
Size:	63.4 KB 
ID:	36421

  2. #2
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,389
    Looks like a pretty straightforward Many-to-Many setup.
    Add all the foods to tbFood with a field to identify entree, appetizer, dessert, vegetable, etc.
    Add a form/subform with events/food_event.
    A dropdown in the subform would allow you to add foods to the food_event table for the event.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 02-13-2018, 07:06 PM
  2. Items in stock from multiple categories
    By Nocs in forum Queries
    Replies: 9
    Last Post: 11-03-2017, 04:38 AM
  3. Replies: 6
    Last Post: 10-09-2015, 12:06 PM
  4. Replies: 5
    Last Post: 12-28-2014, 04:42 PM
  5. Replies: 3
    Last Post: 10-20-2012, 09:18 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums