Recent content by shaul-r

  1. S

    Filter form using a query not in the record source

    Thank you for your help! ProdDim is a subform. How would I filter the main form to return products that do not have a match on the subform? Thank you again in advance!
  2. S

    Filter form using a query not in the record source

    I have one form which houses all my product information via the use of a query and subforms where appropriate. I would like to filter it in order to find records missing certain information. I want to filter the information using a combo box. The combo box has a user friendly name (Product...
  3. S

    When should I base my form on a seperate query?

    I am a beginner and I have come across a question that maybe someone more experienced can help me with. It seems one can create a form in one of two (basic) ways: 1) One can create a form off of a previously designed query or table 2) One can create a form and designate the tables he would like...
  4. S

    Cascading Combo Box

    Thank you for the advice. I have known that this structure needed to be normalized since the beginning, but I had another issue then (which I still haven't worked out) which was I didn't want empty columns when it was exported as a cross tab query. If you could tell me how to answer my first...
  5. S

    Cascading Combo Box

    Cascading Combo Box?! Help ME Please! I have three tables: 1) store_info: store_id, name, url 2) category_by_store: cat_id, store_id, cat_type, cat_parent_name, cat_name, cat_path 3) cat_by_product: ID, sku, store_id, cat_1, cat_2, cat_3, cat_4.... cat_15 The table category_by_store.cat_type...
Back
Top Bottom