lookup in query

[spinkung]

hi all,

I am trying to write an updte query and 4 of my fields are lookup to a table called option (which is a yes/no/NA table). Can i have the yes/no/na table in my query linked to each of the 4 fields in my entry table. I have named the i.e. FDD: option, CD-ROM: option, DVD-ROM: option, CD/RW: option. But when i save the query and then go back into design view there is only one column for the option field with criteria: "yes" And "no" And "no" And "yes".

Do i need to have a seperate lookup table for each of the 4 fields in the entry table for this to work?

cheers,
spinkung.

 

[KjWhal]

hi all,

I am trying to write an updte query and 4 of my fields are lookup to a table called option (which is a yes/no/NA table). Can i have the yes/no/na table in my query linked to each of the 4 fields in my entry table. I have named the i.e. FDD: option, CD-ROM: option, DVD-ROM: option, CD/RW: option. But when i save the query and then go back into design view there is only one column for the option field with criteria: "yes" And "no" And "no" And "yes".

Do i need to have a seperate lookup table for each of the 4 fields in the entry table for this to work?

cheers,
spinkung.

Look up how to alias tables.

You're going to end up with something like this

SELECT floppy.Option, cd.Option, dvd.Option, cdr.Option
FROM tblEntry AS floppy, tblEntry AS cd, tblEntry AS dvd, tblEntry AS cdr;