01-15-2005, 10:27 PM
|
|
Loving joys
|
|
Join Date: May 2001
Posts: 393
|
|
|
The question is:
The project is too complicated to explain here but briefing on the question is, I have to identify the SITC (Standard International Trade Classification) code for each product of customers. The SITC system is a 5 digit system where the 1st digits represents the main commodity, 2nd digit reperesents commodities under it. As an example, an SITC code starting with 0 would represent Food and Live Animals and 01 would be Meat And Meat Preparations and so on.
What I needed to do has, when the 1st category was selected by the 1st category combo, the 2nd category combo would only give the data from the selected category in the 1st combo. I've done that with each combo's requery and works fine.
Works fine when entering data but not as so when editing it.
We don't have anything wrong with the 1st combo as it's "limittolist" propery is set to yes (like all others", but when editing, when I change the value of the 1st combo, the 2nd remains same even though the combo box is populated with the 1st combo's values. What I want to do is, if user leaves the 2nd combo same even though the 1st combo is changed, i need the program to interfere.
I've seen many questions and how-to's regarding adding an item to the combo but in my case i just want to restrict and have the user select what is defined.
__________________
I always wanted to fuck reality but reality always fucked me before.
Angels in America
|
Hybrid Mode
