Search results

  1. A

    Joint Table Primary Key

    You should be proud of what you did back then. Contributions like this one last for ever. Thank you Pat.
  2. A

    Joint Table Primary Key

    Your point about my misunderstanding the Table/form relation is right. And I am trying hard to correct it. As you must realize I am talking basics here. Let me proof it: tblProduct PK ProductID auto, ProductName text tblOrder PK OrderID Auto, OrderName text tblProductOrder PK =(PK ProductID...
  3. A

    Joint Table Primary Key

    Very well explained. Let me take you to real world situation. I have two tables with many to many. Neither of them has FK. So, I created an EMPTY joint table. AND to avoid duplicates I used Composite key(PK1+PK2) in the joint table. So far so good. Now I need to use a form/subform to CREATE the...
  4. A

    Joint Table Primary Key

    In a many-to-many relation, one create joint table and use two columns of both ID's in a Composite way. This what the text books recommend. I had a Form/subform to view the relation between the two table. I tried to add to the subform a new relation Access did not allow me to do it. I can go to...
  5. A

    Form to Select records without VBA

    Thanks for attempting to explain the VBA provided. And yes I do not have that. What is confusing in his VBA is using RESULT and it is a LABEL for the subform. I opted to avoid VBA altogether and use buildin macro to requery the subform based on the query I mentioned above. I am really...
  6. A

    Form to Select records without VBA

    I tried Private Sub cboCity_AfterUpdate() Me.sfrmSearchCity.Form.Filter = "[App_Status]=" & Chr(34) & Me.cboCity & Chr(34) Me.sfrmSearchCity.Form.FilterOn = True End Sub did not work !! Also a side remark It is only ONE TABLE your example is using TWO Tables
  7. A

    Form to Select records without VBA

    Thank you for your support. You used VBA, and I do not understand it. Private Sub Combo2_AfterUpdate() Me.RESULT.Form.Filter = "[App_Status]=" & Chr(34) & Me.Combo2 & Chr(34) Me.RESULT.Form.FilterOn = True End Sub my Combo Box name is cboCity my subform name is sfrmSearchCity my...
  8. A

    Form to Select records without VBA

    Hold your horses.... You mean go to event (after update ) ??? If yes ...what do I do there. The query above is in the subform....
  9. A

    Form to Select records without VBA

    The table has PK and city column can be one of several. I need to create a filtered datasheet view (few columns only) Since there are quite a few cities, I need to select one to display all the records in that city. My questions Since it is a datasheet view I cannot use Combo Box. What to do...
  10. A

    Create proper relations

    That IS good news because I just remove it!!! You wrote to me asking to avoid using my skydrive as link for you guys to get a file I am attaching to my post....Your reasons were quite acceptable, so I removed it ... And I edited my post to refere to the data further down in the post, where I...
  11. A

    Create proper relations

    I removed the link that made you...mad !!!!!
  12. A

    Create proper relations

    Thank you for taking the time to look at my initial work
  13. A

    Create proper relations

    Products is what I SELL. Crops are what they produce ( Apple, Banana). These crops suffer from stresses and I come with my products to help them out. So the triggering of the process is a farmer producing a CROP, got infected by stress. My products address these stresses, but the trigger is...
  14. A

    Create proper relations

    A very good question ? I will try to answer If we address the first part ( Product, Stress, Crop ) Let us exclude the client part If we get the relation right, then I can query a crop (in theory) to know all possible stresses AND the Product to cure these stresses. The permutations are endless...
  15. A

    Create proper relations

    Gina, you are in my Client list .... just kidding I have up to day 17 ....yes 17 (google the names Below) tblStress StressName Soil-born Diseases Nematodes Early Blight Late Blight Downy Mildew Powdery Mildew Aphids Jassids Leaf Hopper Leaf Miner Mealy Bugs Mites Spider...
  16. A

    Create proper relations

    Gina, the product is Bio Fertilizer used in Farms to cure Fruits vegetables etc
  17. A

    Create proper relations

    There is one to many between Product and Stresses Crop can have many Stresses and Stress can be in many Crops. Many to Many. In simple terms, A product can cure more than one stress A Crop can have more than one stress. A product can cure more than one stress... Am I chasing my tail !!!!
  18. A

    Create proper relations

    Here is the database as an attachment
  19. A

    Create proper relations

    Thank you for your remark, can you please direct me on how to it.
  20. A

    Create proper relations

    Here is my first take I posted the database with the relations further down in my post I also removed the link here due to objections from your admin. Is the table design ok? If yes Is the relations OK?
Back
Top Bottom