Lookup Wizard Data Type Field

[Cascais]

Hello,

Could someone please help me ?
I need do make a lookup wizard field in a certain table.
I've got the values in other table.
The Access only permit's me to put the values if I type them one by one.
I need to bring the values that I've got in the other table.

Thanks in advance,

Cascais

 

[PHV]

Perhaps the SQL In[/i] operator ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Cascais]

Ok
Thank you.

Cacais

 

[dhookom]

If you are attempting create lookup fields in table designs, consider reading about their evils at

http://www.mvps.org/access/lookupfields.htm.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[balllian]

here is the stucture of the database

Question tbl

QuestionID -PK
Areaid -FK
Question -datafield

Area Tbl

Area ID -PK
Question Area - datafield

Responces list

QuestionID - FK
Responce - Yes/No
Comments - Datafield

Responce_capture*

Question_ID
Name_ID
Responce -Yes/No

*This table would capture the data after the questionaire has been completed. I want to record the reponces from what is 'responce_list' to be captured in 'Responce_capture' with details recorded from this table.

I want the questions to appear on a form and once this has been completed the responces to be saved and also the nameID to be populated against all 48 questions.

User Tbl

NameID - PK
Name of Business - Datafield

i hope this is somewhat easier to understand.

 

[dhookom]

ballian,
You posted this response in the wrong thread.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[balllian]

apologies.