Button to LINK to other Database according to parameters

[Nukles]

Hello,

I need to interview some people, but questions (with a given value) vary according to the organization they belong to.

I would like to make a form like this. The interviewee selects his organization, then he presses a button and it is automatically redirected to the database particular for that Organization.

Or else, I would like to filter only those questions that regard him (we have a db of questions numbered 1-100, and one Org has for ex. questions 6-34-89, another one has 1-6-88, and so on).

How do u suggest me to operate?

Thanks!!!

PS - As I am a newbie, please be as clear and possible (I say don't assume that I know things that for you are straightforward ;-))

 

[Remou]

How far have you got? Have you tables that show which questions are relevant to which organization? Have you databases set up relevant to various organizations (rarely a good thing)? Have you forms or filters?

Have you looked at Duane Hookom's At Your Survey (

http://www.rogersaccesslibrary.com/OtherLibraries.asp)?

Have you studied the Northwind sample database that ships with all access versions?