Hi

I am trying to link lists within Access using VBA within the same table, but don't seem to be able to get it to work.

Here is the table format.


col1 col2 col3 Tag Title
A W Fishing
A 1 X Freshwater
A 11 Y Pondage
A 12 Y Streams
A 2 X Saltwater
A 21 Y Bank fishing
A 22 Y Boat fishing
B W Farming
B 3 X Cattle farming
B 31 Y Range farming
B 32 Y Feedlot farming
B 4 X Crop farming
B 41 Y Market garden farming
B 42 Y Broad acre

Col1 can have many categories, say, A through Z. I use a query to select and list by tag all of the titles and the corresponding value in col1, col2 or col3. To start the process we choose a title, say, fishing. The title fishing is written to a field "title" in the table. Now, this is where I get lost. I then want to write the "col1" value (A ... Z) for that title in another field in the same table, say "col1 value". I then want to be able to list only those col2 titles that have the same col1 value (A...Z). In this case Freshwater and Saltwater. From this list I then select a title (say, Freshwater) and write the corresponding value (1)in "col2 value". Only those col3 titles that meet the col2 value criteria are listed. In this case Pondage and Streams. A col3 title is selected (Pondage) and the corresponding col3 value (11) is written in the "col3 value" field.

I think this should be quite simple, but can't figure it out. I have done it using the structure of the table, but I need to be able to do it using tags as they will be the best means of control over data selection by query.

Any help will be appreciate.

Thanx.

Adrian

Your description of the problem is confusing. If there are fields in your sample table that are
not relevant to the solution (like Tag appears to be) then leave them out. A sample of the table
you would expect as output would be much more useful than a description of what should happen.

I suspect that a few relatively simple queries (or perhaps just 1) would solve you problem.
Without a clearer idea of what you want, I can't take it any further.


-Phil-