new records from a form, but a blank field

[Darth Vodka]

hi

if i have a query that has an outer join in it and then a Dynaset (Inconsistent Updates) form on top...

then you add a new bit of data on the (unpopulated) outer side of the data and it looks fine in the form

but what it actuallly does is create a new record with a blank field (instead of the field needed to link it back) and if you close the form and re-open the data doesnt link up and is lost

is this always going to be the case?

am i going to have to use a linked sub form?

 

[Pat Hartman]

You need to include the FK field from the related table so Jet can populate it.