add to a comment to a database

[n0795]

ok this may sound confusing but i will try my best..
I have an access database with two tables..
one called names,and one called questions
The two tables are linked....

Right now i can add a name to the name table from my web page...

but to add a question i go to a page that displays the question textarea and also a drop down box listing the names from the "names table".
At the moment you have to select a name from the dropdown box so the question knows where it is going....

Are you with me?
What i want to do is when i search the questions have two more fields come up one saying "Add a question" and one saying "post a question" so that the user doesnt have to search for the name in the drop down box....

Does this make sense?

 

[Tmconsult]

I think I understand your setup. you have an access backend with a webpage frontend. The table lists the name of the person with the other table list the questions posted by that person. But I dont follow what you asking, Why when you search questions do you want to add or post a question. and how would that eliminate the user not using the drop down box which lists names, It still needs to know what name to associate that question with. Id like to help, could you explain it differently.

 

[n0795]

Its kinda confusing
Im using some code i found on the net but i dont know enough about it.
Im learning.......

Heres what it does.
Its called link system and its for people to post like reviews or questions in a forum.
It has two tables in a database which are linked it also has a page where they can read the review/questions and post answers..

My first problem is that it displays all the question subjects and answer/reviews on one page so i changed the code so that they could search for the questions and it displays the info in a table like form on a web page.

This is somewhat what i want BUT when they want to ask a question they get directed to a page which which is a form.
The first thing they have is a drop down box which has all the question subjects posted so far in it"dynamicly from the database".
At this point they can select a question subject or add a new question subject then in the textarea they can write the question.
Then it gets posted to the question they picked.....

This all sounds good but lets say at sometime i get 700 question subjects nobody is going to want to scroll down till they find the subject they want..

Which leads me to my Problem.
When they search the subjects and it displays the table can i dynamicly put that subject where the drop down box was so it knows where to put the question .
Sounds confusing to me but I know it must be possible.