How do you CREATE a TABLE with a COMBO BOX field?

[hazlehurstga]

I need to create a new table using Visual Basic, and the new table must have a field with LookUp type of Combo Box.
How does one use the CREATE TABLE command to create a table with a Field with the Combo Box Lookup type?

Thanks,
hazlehurstga

 

[RoyVidar]

I would say you shouldn't. This link The Evils of Lookup Fields in Tables says the same.

If you need lookups, use combos in forms, as you shouldn't expose the tables to your users anyway, only forms and reports.

I doubt it's even possible thru the SQL, since it is more a field formatting issue than datatype.

Roy-Vidar