where to start....

[Little pete]

Looking at creating a asset register, all data is on paper so unable to do
massive dump into tables. want to create a form that will do the following
but need to make sure i set up the tables etc correctly to start off with.

group
1

sub group
1A
1B

subsystem
1A1
1A2
1A3
1B1
1B2
1B3

I want to start the selection on the form at the bottom of this tree ie
enter the sub system and then have the system complete the rest.
Question 1 What do I need in my tables to allow this?
Question 2 How and what functions do i need on my form?

Thanks pete

 

[Geof Wyght]

Pete,
I would be tempted to have just 1 table with 3 fields. The
list box on your form will be populated by a query that
looks like this:
Select group, subgroup, subsystem, group & subgroup &
subsystem AS groupdetail From ...
Make the column widths of the 1st 3 columns zero. When the
user selects an item from the list you can refer to
Me.listGroup.Column(0) and so on...
Does that help?
Geof.