Heres the setup in Access. I have two tables with a relationship one(T1) to many(T2). T1's key is a foreign key in T2. I have a form that displays T1 data and a subform that displays T2. When you change records in T1, the subform records change according to the rules in the relationship.
All is well until you add a new record in T1. The record gets added in T1 as expected, but because there is no record in T2 that corresponds, the subform just hangs on whatever was last displayed.
From T1, can you trigger an Addnew type event in the subform? This sounds simple but I totally can't figure this out!
HELP... A+, N+, MCP
All is well until you add a new record in T1. The record gets added in T1 as expected, but because there is no record in T2 that corresponds, the subform just hangs on whatever was last displayed.
From T1, can you trigger an Addnew type event in the subform? This sounds simple but I totally can't figure this out!
HELP... A+, N+, MCP