Split form updates all records

[pbruce66]

I've created a split form with a search field at the top of the page that will search for any part of a name. The form is based on a query that uses multiple tables, members is the primary table with membership types as a related table. All tables have a primary key and the primary keys on the dependent tables are linked to a field on the primary table. The list of search results appears in the bottom datasheet and the detailed info in the top. The problem that I have is when I update fields that are linked from a dependent table all records that appear in the bottom datasheet form update.



Has anyone seen this?

[ranman256]

That would happen. (If I understand you)
if you alter the source table ,say tCountry table,key = 123, name= Spain.
keep key, but change Spain to France, then all records using 123 are now France.

if this is NOT your example, then you must have some other parent /child relationship that is similar.

[pbruce66]

I haven't gone back in to look but I think this is exactly the problem. As soon as I read it I understood why the datasheet was acting like that. Thanks!