Table lookup issues

[munkeyroot]

Hi everyone, its been I while since I've done a db and prob being thick but here goes.

I have a parts list with part type part descriptions and costs etc this was imported from an excel Sheet Into a table (I have created its own key). The parts list cannot be split up as it gets updated from another program.

I also have a front end form which users will use.

On the form i have created a subform called panel this is so when a user uses the form they can select drop down's which lookup the partslist on a specific column they can choose. So they can DD the partstype then from what parttype they choose then the item decsc DD will only choose the item from the parts list.....phew!. Hope that clear as mud.

The issue in having is the lookup on the panel for partstype I can get the DD to link to the partslist but each item lists I cannot get it to group as in all one part item and then the to once select only to show those parts in that group.

I hope that makes sense. Any help would be Brill!!

Cheers munk

 

[NauticalGent]

If I understand this correctly, you are wanting the drop-down options of one combo box to change according to a selection from another one?

 

[The_Doc_Man]

You might want to search this forum for the topic "Cascading Combo Boxes" which addresses the general method involved in making one combo box's content sensitive to the selection made in another combo box.

The forum Search function is in the narrow ribbon under the rectangle at the top of the page that says "Welcome, username" and is third from the right.

 

[munkeyroot]

Hi Doc man, thank you for you time for this i will take a look and thank you to NauticalGent for your comment i will try to a db on here so i hope it will make it clearer

cheers munk

 

[munkeyroot]

Hi Guys
thank you for your time, ive managed to strip the db out so thier is only sample info (data is sensitive) and also put an execl spreed sheet in that i am basing the db on and also the db it self.

so i have created the form sales tool from the index table

their is a parts sample table this has the Fields but only sample data,

i hope the excel make sense...sorry if i'm struggling to make myself clear

hope you can help, i'll try to answer question the best i can

regards munk

 

[munkeyroot]

Hi Guys
i have been having a re-think on the db.
on the index form their is a System Combo box i have populated this by the systems column from the parts_listexl
(I can get this to link to the table but lists every individual entry when i use the combo box . not sure how to get them to only show one of everything. this seem to happen to every combo box from the parts_listexl)

i have created a new table called Orders, which has Part Type and Item desc columns. I am looking then into the idea of the what is selected in the "system" combo to then only give a select of the part type on the subform the the part type to only show specific items in the item desc.. what do you think is this possible?

hope you can help
munk

 

[Minty]

You can create a query in the combo box record source to populate your combo boxes with any values from any table.

So if you used a Totals query and selected only the fields you needed for the combo box and selected GroupBy as the grouping it would give you what you need.

 

[munkeyroot]

Thanks for your time minty i'll give it a go

munk

 

[munkeyroot]

Hi Guys thank you so much for your help and pointing me in the right place, however stuck again lol.

ok so here is how far i have got.
I have managed to setup the Qrys for the cascading combo boxes:
and set up a combo box on the "frmMainSheet" "System" which will pickup all the "system" data from the "Parts_list" table which is set to group by.

I have a Subform on the "FrmMainSheet" made from the "Order" table, the "Parts Type" and the "Item Desc" are combo boxes set to pickup the data from the part_list.

The "Parts Type" set to order itself depending on what choice i make from system - this works great.

I have tried to do the same for the "Item desc" so it only loads what choice i make from the parts type but it either shows a blank drop down or it gives an enter parameters value OK or cancel box. i am not sure what i am doing wrong.

future info for the subform:
once i have the Item desc issues sorted i am looking for it to automatically update the Purchase and sell price with their details.

thanks again Munk