On the Form n List module  - when used as a web form, blank fields do not show as an entry in the database.
(in the table: UserDefinedData)

Is it possible to make all fields on my web form log an entry (even if the user leaves a field blank)?

I realise I could either make it a required field or insert default text -
(but don't want it as a required field and the user could always start to insert something and then delete it, so default text  doesn't seem ideal).

thanks in advance,
mark.

The reason for this is to create a view which shows all records just from one particular form.

The UserDefinedData table shows an amalgamated list of fields from all our forms.

The code below shows our query which we have tried to use to show only results from one form (but if the user leaves a field blank - the entire record is not pulled in to the view).

-----------------------
CREATE VIEW dbo.vw_EmailRegistrations
AS SELECT TOP 100 PERCENT
owner.UserDefinedRows.ModuleId,
owner.UserDefinedData.UserDefinedRowId,
owner.UserDefinedData.FieldValue AS EmailAddress,
UserDefinedData_1.FieldValue AS NINo,
UserDefinedData_2.FieldValue AS Surname,
UserDefinedData_3.FieldValue AS Forename,
UserDefinedData_4.FieldValue AS Telephone,
UserDefinedData_5.FieldValue AS Mobile

FROM owner.UserDefinedRows INNER JOIN
owner.UserDefinedData ON owner.UserDefinedRows.UserDefinedRowId = owner.UserDefinedData.

UserDefinedRowId INNER JOIN
owner.UserDefinedData UserDefinedData_1 ON owner.UserDefinedRows.UserDefinedRowId = UserDefinedData_1.UserDefinedRowId INNER JOIN
owner.UserDefinedData UserDefinedData_2 ON owner.UserDefinedRows.UserDefinedRowId = UserDefinedData_2.UserDefinedRowId INNER JOIN
owner.UserDefinedData UserDefinedData_3 ON owner.UserDefinedRows.UserDefinedRowId = UserDefinedData_3.UserDefinedRowId INNER JOIN
owner.UserDefinedData UserDefinedData_4 ON owner.UserDefinedRows.UserDefinedRowId = UserDefinedData_4.UserDefinedRowId INNER JOIN
owner.UserDefinedData UserDefinedData_5 ON owner.UserDefinedRows.UserDefinedRowId = UserDefinedData_5.UserDefinedRowId

WHERE (owner.UserDefinedRows.ModuleId = 873)
AND (owner.UserDefinedData.UserDefinedFieldId = 90)
AND (UserDefinedData_1.UserDefinedFieldId = 89)
AND (UserDefinedData_2.UserDefinedFieldId = 88)
AND (UserDefinedData_3.UserDefinedFieldId = 45)
AND (UserDefinedData_4.UserDefinedFieldId = 149)
AND (UserDefinedData_5.UserDefinedFieldId = 167)

ORDER BY owner.UserDefinedData.UserDefinedRowId

----------------------------

* Also tried outer joins, but this also failed to show the records which contained blank fields.
* And tried to allow and not allow NULLS in the field too.