Default value in table doesn't create a record

[krowe]

Hi

I have a main table with a form to put the data in.

I then have a sperate table to put additional information in (a subform of the main form, linked by ID). Originally i thought this was best as not every entry in the main table will have additional info. However when I came to create queries using data from both tables, a main table entry without an additional info entry would be filtered from the query.

To resolve this I put a default value in the additional info form, thinking that this would create a record for each main table entry. However this does not appear to be the case.

How can I get the default value to create a record every time.

Or, how can i get a query to return results where the is not additional info record associated with the main record?

Thanks

Kev

 

[krowe]

Thinking about this, it may be more of a query problem, or rather the solution probably lies in the query and not the table, so i'm going to repost in that thread.