Search results for query: *

I am having problems understanding your first line of example code. It looks like your trying to select a field (Name) from a table that doesnt carry that field (Lookups). Maybe this is my inexperience talking but can you do that? EDIT: Never mind I figured out what I was doing wrong. The only...

yeah i see what you are saying. I will try this when i get home from work and let you know how it goes

Well I am not against changing my database structure. Im still semi new to working with database and want to nip bad habits in the bud. Can you go into a little more detail on your suggestion?

I am using Visual Studio 2010 and Microsoft Access 2007 I am not sure of the best way to describe my problem, but here goes I have a query (PartsQry) in access that has 6 columns (ID, KYWD1, KYWD2, KYWD3, KYWD4, KYWD5). The KYWD columns hold various keywords that are specific to the ID. In my...