Recent content by arishy

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

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...

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...

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...

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...

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

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...

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

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...

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...

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

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

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...

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...

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...