Question Generate info from form selections?

[whitelockben]

I want to create a form with cascading combo boxes ... but I want to generate coes from this e.g.

E.g.

Drop Down 1

Meat
Vegitables

Drop Down 2 (when meat has been selected in 1)

Beef
Lamb
Pork

or

Drop Down 2 (when veg. has been selected)

Carrot
Pea


I have done that with cascading combos, using a single code source table.

Now I want a code to be generated for each combination e.g.

If meat, beef is selected a code would be generated ... M-B. In the source table I have a row with the code in for each selection.

I want to do this to much longer conbinations though, can anyone help me. At this time I am not too concearned about adding the code into a table, but further down the line I would like to be able to add a title and generate a code and these be saved in a table.

e.g.

Code & Title
M-B - Week 1

I hope this makes sense. Thanks

 

[GinaWhipp]

I do not understand... Sounds like part one works (and makes sense). However, I do not get part two... please elaborate.