hierarchy tree set up

[Little pete]

I am setting up a database with (I think) a hierarchy tree set up.
With a total of 4 steps starting with group (1), sub group (2), system (3),
sub system (4). Each step contributes a unique number/code such as WGTN for
Wellington - LAE for lifts and escalators etc so in the end we get;
WGTNLAE.......

How do I create a form which allows the user or system to create these
number/codes etc. I have created the tables with wordy version and codes,
now need them to select the wordy version which will then display all 4
unique codes in a seperate cell.

Thanks for the help,
pete

 

[Sprinks]

Hi, Pete. I'm not completely sure I understand what you're trying to do, but
will give it a try.

Assuming these codes all pertain to different fields, I would not attempt to
assign the merged codes to *another* field, just display it on your form. An
easy way to do that is to create combo boxes for each field that include the
code and the text as columns.

Then a display box could show the composite code text by setting its control
source to:

[Combo1].Column(1) & [Combo2].Column(1) & [Combo3].Column(1) &
[Combo4].Column(1)