Results 1 to 1 of 1
  1. #1
    Join Date
    Apr 2005

    Unanswered: Proper Database Relationships

    The attached image shows my simple Order Entry database modeled after the Microsoft sample TG_136.mdb . I changed the Products table to Services & added the extra tables on the right.

    Question: How Do I add Multiple Features to a Service?
    Did I do this right?
    How do I create my subform to allow adding MANY features to a tblService?

    I would like to have a subform that has the list of all 10 features, and have a check-box beside each. That way the user could just check the ones that apply. If I used this arrangement, how do I make sure that each feature chosen is recorded correctly in the tables?

    Thanks in advance for your ideas & help!
    Attached Thumbnails Attached Thumbnails OE Relationships.gif  

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts