469,283 Members | 2,303 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,283 developers. It's quick & easy.

parent child relationship with datasheet view

I want to have a form with 2 subforms...1 subform would be the parent table...and the 2nd subform would be the child table and they both would be in datasheet view. I want to see all records in the parent table and when I select a different record it would only show me the records in the child table/datasheet that is related. What is the best way of accomplishing this? Any samples out there?
Sep 28 '10 #1
1 2546
14,534 Expert Mod 8TB
Hi Alex

The only way I can think of for you to do this would be to have all the records in the child subform and filter it based on records in the parent subform. I think perhaps the On Current event would be appropriate to use.

For more information on filtering forms, check out this insight.

Cascade Form Filtering
Sep 29 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by steroche | last post: by
3 posts views Thread by B-Dog | last post: by
3 posts views Thread by reachsamdurai | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.