Two subforms

[C Tate]

I recently created a main form in the style of the customer order form in the
Northwind database. It has two subforms and I've linked them together so when
you click on a line in the first subform, the relevant records appear in the
second.

This is a very convenient way for me to look at my records. What I was
wondering is this: is there any good reason why I shouldn't use this method
for data entry? I've tested the forms and everything seems to work ok.

I just wondered why none of the books seem to suggest this method (or at
least the ones I've read!). Thanks in advance.

 

[ruralguy via AccessMonster.com]

It is a perfectly valid method for data entry. I've used that method for
years. I usually put a delete control on the right SubForm so a single record
can be deleted. It is important that you have Referential Integrity enforced
so there are no orphaned records.