NeedToDisplayFullDescriptionOfComboBoxSelection 1

[CliffordTheRedDog]

Apologies for longish post, trying top be precise!
I have a form which shows a combo box. The list shown in the combo box "codes" are routes for our manufacturing process. The Table from which this list is taken has short code and Full Description of route.

i.e. P,W,E stands for Pierce, then Weld. then Enamel.

When entering some of these routes i would like the option to display the full discription as a prompt for the Form user during selection. The data that would be enterered is obviously the short description. As these processes can evolve i would like the long description to be bound to the table also. The solution i have come up with so far is to add a command button which sits next to the combo box and allows the user to view the table with both long and short description. The best solution would be to select the route as a long description from this table and the form inputs the short description. The reason for the short description is that it gets printed on a control sheet which is used to direct the parts around the company and space is a minimal.
TIA
Cliff

 

[CliffordTheRedDog]

Don't answer I have found it curtisy Manxman

http://www.comeandread.com/access/tip015.htm

Cliff

 

[KenReay]

Hi

I am not too sure if I understand your data structure, I think from what you say, you simply want to have a multi column combo box, in which case I have a FAQ in the forms forum (Comboboxes - Using Multiple Columns faq702-4284) which may help you.

I understand the concept of having a 'routeing' table, but on the occasions I have been involved with application such as this my approach has been to have

tblWorkCentres
WorkCentreId
Description
...etc

tblRoute
Sequence
WorkCentreId

rather than have a 'compound' column which contains 'n' route codes, I an not sure which approach you have taken

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[CliffordTheRedDog]

Thanks KenReay.
We did decide to go the compound code way. The database was developed from an existing requirement and future proofing certain parts in mind. I see your way of doing it and wonder if we made the corect choice of presenting the same information. The Part control report displaying the info has a fixed column for routing. If i could have a form (subform?) on the part creation form which showed all available codes with a spin wheel number and each code used could be numbered in the routing order that would be great. The next thing would be to have the report assemble the chosen codes in the routing order selected by the spinwheel numbers. As I have only been using access a very short time, it is understanable that i chose the compound option. Currently there are only a few possible permutations.
Thanks Cliff