SQL to Access 2007 "dropdown" field

[punky001]

I have a field(nvarchar(50) in a SQL table that I want to use in an Access 2007 linked table as a "dropdown" field. I link the table to the Access database but - because it is linked - I cannot use the Lookup wizard as datatype to define the field.

How do I define a dropdown list in Access 2007 from a SQL linked table?

I would appreciate any help.

 

[simian336]

I assume since your using it as a drop down your not talking about millions of records. I would just import the field in question into a table then use it for your drop down.

Just delete it and recreate it each time.

Simi