Good morning,
I have a database (Tests) that has the following fields:
Doc_ID (Text)
Doc_Title (Text)
Test1 (yes/no)
Test2 (yes/no)
Test3 (yes/no)
Test4 (yes/no)
Test5 (yes/no)

Here is my dilema, I do not want to put the same Doc_ID (eg. doc_123) for 3 different tests to be run. (eg. Doc_123 needs Test 1, Test 3, and Test 5 to be run) Is there a SQL statement or maybe a script I can write to call to the Database for that one record to display the results 3 times on my webpage? (Instead of me creating a new Doc_Id for the same record 3 times in the Database) Does this make any sense?
thank you for your help.

I dont understand, consider the following:

Doc_123 'MyDoc' Yes No Yes No Yes

Pulling that row from the table would tell you that Test 1 3 and 5 need to be run on that document, correct?

"The one language all programmers understand is profanity."

yes,
but i need it to pull to the web form like this:
doc_123 test 1 .......
doc_123 test 3 .......
doc_123 test 5 .......

I want to write the script that goes to the database and if the record has more than 1 test then it lists them on the webpage.
Currently i have the same record in the database 3 times for 3 tests, when i could have it once using the yes/no function for the test fields.
thank you for your help