Help with combo box

[webfactoryuk]

I appreciate im waaay out my depth and past forum help.



Dont wanna waste your time!

Can you just help with the 3 combo boxes on the Racking Components Screen form?

Component
Action
Defect

All the options are in the table called Rack Comp Defects.

I was under the impression I could set it up like that and make the combo boxes dependant?


ps - if you did want to help, im a web developer by day (bad Access user by eve) so if you need a site or anything like that Id be happy to return the favour!

[webfactoryuk]

We're just trying to get the Racking Component Screen form working right?

Posted at the same time.

Yea thats right. As above.

[RuralGuy]

Both the Component cbo and the Defect cbo seem to be looking at the same table which does not make a lot of sense to me. Where would I find a legal list of defects for each component?

[webfactoryuk]

Thats just me not knowing what im doing!

Thought that was how I could set it up.

How else would it know which defect and action applied to which component?

The best list I have is in the table youve seen.

The reason ive put N/A for most of the defects is because I need to sit down with my mate and find out which belongs to which. I dont do inspections myself!

[RuralGuy]

Normally you would have a "Lookup" table with all of the "valid/legal" defects associated with the various components. Then your 2nd cbo could point to this Defects table and simply limit the selection by whatever is selected in the 1st cbo. The best you can get using the same table for both is listing defect you've already used for that component. Is that what you wanted to do?

[webfactoryuk]

No it sounds like I need it the first way round that you explained.

Need to be able to open the file from new. Select a component, the second combo box will then show the relevant defects and then the third would show the actions that apply to that defect.

Component: Beam

Defect: bent/twisted/loose

Actions: replace/straighten/tighten (examples of actions)

[RuralGuy]

Your [Rack Comp Defects] table has different values in it. In what table would I find the values you just mentioned?

[webfactoryuk]

Im not being helpful here. I just made those up as an example of how it would cascade down.

I thought I would be able to have the data as it is in my Rack Comp Defects table with all the components, defects and actions listed as they are.

The first combo box I would ideally setup to look at the components column in that table but to only show each component once ignoring the repeats in that column.

The second combo box would get the data from the defects table dependant on what had been chosen in the first combo box.

And then basically the same for the 3rd combo box for actions but it would be dependant on the 2nd choice rather than the 1st.

Just googled it and this guy is doing a similiar thing reading the first post except he only has 2 combo boxes.

He says he has it all in the same table too.

http://www.access-programmers.co.uk/...d.php?t=135928

[RuralGuy]

I finally figured out why your system works at all. You did not follow this link: http://access.mvps.org/access/lookupfields.htm I suppose we could try and get what you have working better, but I'm not sure I'm up for it.

[webfactoryuk]

As I say my system does the job for what it needs.

Just need the combo boxes to work lol. I can get them working on there own but want to shorten the list available when you look at defect and actions.

Thats all.

I didnt expect you to spend too much time on it so thanks for what you have done!

[RuralGuy]

I would expect that the [Rack Components] ID would be the ID that is used in your system but the [ComponentID] in the [Rack Comp Defects] table does not agree with my expectations.

[webfactoryuk]

You assume I know how to set up IDs.


Forget the entire database. Can you not just make it so the combo boxes work?


I found a guide where someone setup a regions drop down box which listed US states.

Then once you selected a Region it only showed you the cities in that region in the second drop down.

They set there data for the combo boxes up just like I have. I just didnt understand what they did to make it work!

Trying to find the guide again now.

[webfactoryuk]

Maybe I should try this

http://www.simply-access.com/UsingCo...rComboBox.html

[webfactoryuk]

Ok, trying to simplify this!

Follwing the guide aboce I have splt the Components and Defects (forget actions for now!) into 2 seperate tables.

Rack Comp table has Component ID and Component Name

Rack Defects has Defect ID, Defect Name and Component ID

I have made component id the (think its called) key in the Rack Defects table.
For the first combo the row source is

SELECT [Rack Components].[ID], [Rack Components].[Rack Components] FROM [Rack Components];

For the second combo box based on the above guide I have entered the follwing code

[Forms]![Racking Components Screen]![cbocomp]

And then setup the requery on the first combo box as advised.


Result = the combo box for defects has the number 5 in it and thats it lol.

Re-attached my slightly tidier and re-worked DB file.

www.sambritton.co.uk/rackingcompany2.accdb