I have 2 tables. One table call "tCL"that list all products (text value of CL) and paramets of CL are listed as a string of "BC", with each value of a product separated by a coma. Ex: (8.4,8.6)
I then I have another table tStock that has 3 fields, one for qty, one that looks up from TCL the CL value in a value list so the user can select CL and lastly the third tStock column is BC.
I would like the Stock table to look up BC from the CL table but based on the selected entry of CL in the stock table.
Currently have the stock table CL as a list box with a row source of:
SELECT TCl.CL FROM TCl Order by CL;
This is working fine.
But how I can I setup the stock table BC to lookup BC from tCL based on the CL selected in the stock table?
SELECT TCl.BC FROM TCl Order by CL WHERE TCl.CL = tStock.CL
Is this possible?