Recommendations for a form process

%3CLINGO-SUB%20id%3D%22lingo-sub-1898481%22%20slang%3D%22en-US%22%3ERecommendations%20for%20a%20form%20process%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1898481%22%20slang%3D%22en-US%22%3EI%20have%20a%20data%20set%2Ftable%20that%20will%20grow%20and%20alter%20as%20time%20goes%20on.%20I%20want%20to%20set%20up%20a%20situation%20where%20a%20form%20uses%20the%20data%20set%20to%20filter%20choices%20based%20criteria%20entered.%20So%20for%20example%20box%201%20would%20be%20manufacturer.%20If%20a%20choice%20is%20made%20in%20manufacturer%20all%20other%20boxes%20will%20only%20show%20options%20based%20on%20that%20same%20manufacturer%20from%20the%20data%20table.%20This%20would%20be%20at%20least%205%20or%206%20boxes%20referencing%20columns%20in%20the%20table.%20I%20don%E2%80%99t%20want%20to%20use%20simple%20data%20validation%20as%20the%20table%20will%20grow%2C%20and%20I%20would%20like%20to%20have%20any%20box%20used%20instead%20of%20having%20to%20select%20the%20first%20box%20info%20first.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1898481%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1899495%22%20slang%3D%22de-DE%22%3ESubject%3A%20Recommendations%20for%20a%20form%20process%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1899495%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F872648%22%20target%3D%22_blank%22%3E%40Jaret_B%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExcel%20is%20like%20chocolate%20%3A)%2C%20the%20solution%20approaches%20many%2C%20the%20variations%20many%20more.%20Preferences%20again%20as%20many%2C%20in%20order%20to%20bring%20them%20on%20the%20tongue%20...%20uhhh%20light%2C%20some%20information%20is%20needed%20in%20advance%20for%20the%20recipe%20%2F%20proposed%20solution%20...%20That's%20when...%3C%2FP%3E%3CP%3EWith%20your%20permission%2C%20if%20I%20can%20recommend%20you%2C%20add%20a%20file%20(without%20sensitive%20data)%20to%20your%20project.%3C%2FP%3E%3CP%3EExplain%20your%20plans%20in%20relation%20to%20this%20file.%20So%20you%20can%20get%20a%20solution%20that%20is%20tailored%20to%20your%20needs%20much%20faster.%3C%2FP%3E%3CP%3EAt%20the%20same%20time%2C%20it%20is%20much%20easier%20for%20someone%20who%20wants%20to%20help%20understand%20the%20subject.%3C%2FP%3E%3CP%3EA%20win-win%20situation%20for%20everyone.%3C%2FP%3E%3CP%3EPlease%20no%20Picture%2C%20even%20if%20it%20is%20said%20that%20a%20picture%20can%20say%20a%20thousand%20words%2C%20it%20is%20certainly%20not%20in%20the%20case%20of%20Excel%2C%20on%20the%20contrary%20in%20some%20cases.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Knowing%20the%20Excel%20version%20and%20operating%20system%20would%20be%20an%20advantage.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor
I have a data set/table that will grow and alter as time goes on. I want to set up a situation where a form uses the data set to filter choices based criteria entered. So for example box 1 would be manufacturer. If a choice is made in manufacturer all other boxes will only show options based on that same manufacturer from the data table. This would be at least 5 or 6 boxes referencing columns in the table. I don’t want to use simple data validation as the table will grow, and I would like to have any box used instead of having to select the first box info first.
1 Reply
Highlighted

@Jaret_B 

Excel is like chocolate :), the solution approaches many, the variations many more. Preferences again as many, in order to bring them on the tongue ... uhhh light, some information is needed in advance for the recipe / proposed solution ... therefore...

With your permission, if I can recommend you, add a file (without sensitive data) to your project.

Explain your plans in relation to this file. So you can get a solution that is tailored to your needs much faster.

At the same time, it is much easier for someone who wants to help to understand the subject.

A win-win situation for everyone.

Please no Picture, even if it is said that a picture can say a thousand words, it is certainly not in the case of Excel, on the contrary in some cases.

 

* Knowing the Excel version and operating system would also be an advantage.

 

Thank you for your understanding and patience

 

Nikolino

I know I don't know anything (Socrates)