Hello,
I am a relatively new access user with a small amount of knowledge from an introductory university course. I am trying to create a database for a catering business that includes menu items and their individual prices as well as prices based on the number of attendees (25,50,75,100). I have created tables for each type of food (Appetizers, Breakfast, Entree...) that includes the menu item and an item number, I have also created reports for each table. My idea would be to select individual menu items and the onclick macro will go to a new table that has the cost of the menu item and then cells with formulas to multiply the price by the number of attendees. My issue is that I am unable to select specific menu item numbers to use the onclick macro, I am only able to select different sections of the report such as the labels. Is it possible for this action to happen?