I am relatively new to Access and have a question. I am creating a database for an assisted living community, regarding Dietary Restrictions. My question is: I would like to create a front end user form to add "New Menu Items". I have all tables normalized, but the issue is some "New Menu Items" may have zero restrictions, and some may have many. How do I do this?

  • Also, I would prefer a dropdown style menu to avoid data integrity issues. – Alexandra Ribera Jul 3 '19 at 18:25
  • 1
    Are you asking about how to create the user form or how to structure a database table to allow some menu items to have not dietary restrictions? – Kirk Saunders Jul 3 '19 at 18:27
  • 1
    Looking for subforms? – ComputerVersteher Jul 3 '19 at 18:30

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.