"I am making a survey program in Ac

[05041974]

"I am making a survey program in Access 2000.

There are quite a lot of questions in this program. If the questions are answered a plus, if the questions are not answered a minus will be given.

I could not interrelate the tables. Could you help me to make the program
Can anybody help me out as soon as possible?

Please reply soon...

 

[JerryDennison]

What kind of help are you looking for?

Your question is very vague, can you be more specific as to the nature of your problem?

 

[05041974]

ESPECIALLY I did not know how I can link up between the tables....Honestly I can't know how I tell the problem.

Thanks ýn advance...

 

[JerryDennison]

To create a link or join between two tables you must define a primary key field for the master table and a foreign key link to this field in the sub table. Typically, this is done using an autonumber field in the master table and a long integer field in the sub table. Make sure the foreign key field is NOT set as a primary key. Then in the Relationships view add both tables and drag the primary key from the master table and drop on the foreign key of the sub table. You've now created your join.

 

[05041974]

THANKS FOR HELP
MAY I ASK YOU A QUESTON AGAIN?
I USED LIST BOX FOR SURVEY QUESTIONS.
IF A SELLER DOESN'T ANSWER TO QUESTION;I DON'T WANT
TO APPEAR IT IN THE REPORTS.

HOW CAN I DO?

NOTES:I have a few knowledge about programming I mean I am a new about learning computer systems ...

Thanks ýn advance...