Empty lookup values

[gniko]

I have created a form (and a table ) using fast forms with 3 text and 2 lookup values.
It works perfectly as long as the lookup values are set to a record of the tables they look into.
However I want to insert records in the table without the lookup values.
Saving the records works (The records are saved in the table, I can access them using phpMyAdmin)
However the records are not shown in the browse list so I cannot access them from the nuBuilder environment.

Any ideas how to solve this.

I am thinink of adding a dummy record in the 2 other tables and use it as default value, however I' d prefer to have actually empty values

[gniko]

I removed the lookup columns and the SQL querry from the browse form and I can access all the records now.

I would like to be able to view all the columns so any ideas are welcome.

[gniko]

Well found the solution I modified the autocreated SQL script using LEFT OUTER JOIN istead of JOIN on the two tables.
This returns all the lines from the main table and browse form has all records.

changed the following:

Code: Select all

SELECT
    part.*,
    device.*,
    field.*

FROM
    part
        JOIN device ON part.part_device_id = device.device_id
        JOIN field ON part.part_field_id = field.field_id

with this.

Code: Select all

SELECT
    part.*,
    device.*,
    field.*

FROM
    part
        LEFT OUTER JOIN device ON part.part_device_id = device.device_id
        LEFT OUTER JOIN field ON part.part_field_id = field.field_id

[admin]

.

[toms]

gniko, does that mean it's all fixed?

[gniko]

Yes its all fixed.
Thanks!

[admin]

.