Continuous Form Cascading Combo

[pulsarman605]

I have a query/table with

Darwin	ABCSU	SSCU151010
Darwin	ABCU	2017060113
Darwin	ABUSQ	LT 1023
Sydney	ABSGU	2018221
Derrimut	ABSGU	2018221
Perth	ABSGU	2018221
Brisbane	ABSGU	2018221
Adelaide	ABSGU	2018221

<caption>
</caption><thead>
[TH="bgcolor: #c0c0c0"] LNAME [/TH]
[TH="bgcolor: #c0c0c0"] STOCKCODE [/TH]
[TH="bgcolor: #c0c0c0"] batchcode [/TH]

</thead><tbody>
</tbody><tfoot></tfoot>

I want on a single row. A drop down for LNAME (distinct), then a dropdown for STOCKCODE based on LNAME, THEN BATCHCODE based on STOCKCODE and LNAME.

Can this be done????

 

[pulsarman605]

Doesn't matter..... I think I worked it out... ADMIN please delete post