Empty Datasource causes field to not be editable

[lawrence.farrell]

I am using SQL Server 2000 for back-end of an InfoPath form. The form
contains a list of questions and a list of answers from 2 different
tables. The answer table and question table are connected by using
question number (and a few other fields). The form displays the
questions and answers appropriately. However, when there is no answer
for a question the field for the question shows up disabled. Therefore
you can't enter a new answer. I would like to have the answers in
simple fields like textboxes. Therefore, I don't want to have a
repeating table with an "Insert Answer" prompt.

Currently I have inserted the textbox into the repeating Question
table. On the datasource the Answer table is listed as a child of the
Question table.
Does anyone have an idea for me?

I appreciate your help!

--Larry--

 

[LarryFarrell]

Thank you. I created triggers in my tables to populate corresponding
rows and that worked. It may not be great for a space issue, but I
will deal with that at another time.