lookup in datasheet view based on the entry in other field

[Mark Kubicki]

this is about entering and editing in DATASHEET view (not in a form)
I have a very simple table (3 fields: = Manufacturer, CatalogNumber, Note)


- the 1st field has a lookup from the values in a table: ManufacturerList;
it works fine

- the 2nd field should provide a lookup from the values in a table:
ManufacturerProducts -where the field Manufacturer (in that table) is equal
to the value entered in the 1st field [Manufacturer] of the current
record...

I entered the SQL into the lookup datasource:
SELECT ManufacturerProducts.CatalogNumber FROM ManufacturerProducts WHERE
((ManufacturerProducts.Manufacturer)=[manufacturer]));

This doesn't fileter anything;


any suggestions wouldbe greatly appreciated
as always, thanks in advance,
mark

 

[John W. Vinson]

this is about entering and editing in DATASHEET view (not in a form)
I have a very simple table (3 fields: = Manufacturer, CatalogNumber, Note)


- the 1st field has a lookup from the values in a table: ManufacturerList;
it works fine

- the 2nd field should provide a lookup from the values in a table:
ManufacturerProducts -where the field Manufacturer (in that table) is equal
to the value entered in the 1st field [Manufacturer] of the current
record...

I entered the SQL into the lookup datasource:
SELECT ManufacturerProducts.CatalogNumber FROM ManufacturerProducts WHERE
((ManufacturerProducts.Manufacturer)=[manufacturer]));

This doesn't fileter anything;


any suggestions wouldbe greatly appreciated
as always, thanks in advance,
mark

If you want to do this in table datasheet view...

You can't.

That's one of many limitations to table datasheet view.

If you want to insist on editing (inappropriately) in Tables, rather than
(say) constructing a very simple autoform or datasheet view form, this is just
one of the prices you must pay.