473,387 Members | 1,771 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

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 3094
MMcCarthy
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

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

Similar topics

0
by: steroche | last post by:
Hi, I need to write an Application that shows related tables(possibly >2) in the same dataset. I also need the capability to edit data and save it back to the SQL db.This editing may be done on...
0
by: Steve | last post by:
I have mixed managed/unmanaged C++ MFC application. The mainframe is MFC window and we added new managed form. How can I set parent/child relationship between the new managed form...
3
by: B-Dog | last post by:
I'm trying to comprehend the database features in VB and after tons of reading I'm not sure how do relationships. I want to display a parent column and the respective child columns on one line of...
2
by: RJN | last post by:
Hi I need help in writing a recursive function. My table structure is as below. InstanceId LevelId ParentId 100 1 null 101 2 ...
3
by: reachsamdurai | last post by:
Is it possible to determine the list of child/parent tables for a particular table from any system catalog tables? Using the syscat.tables I'm able to retrieve the no of dependent parent/child...
0
by: CodeMonkey | last post by:
I'm using Visual Studio 2005 (vb.net). I have a dataset with 3 tables in it. I have a main table that has two fields in it, Category and Subcategory. I also have two other tables, one for...
1
by: ppwlee | last post by:
Hi, I have created a main form with 2 subforms, Both subforms are in datasheet view. I want to be able to pick a record from subform1 and the corresponding linked record (created by a...
3
by: creative1 | last post by:
Here is how you create a complex data report that involves parent and child commands and you can update information at runtime. Its pretty straight forward to work with simple queries; however,...
0
by: vivajay | last post by:
I'm trying to do a parent/child relationship in nested datalists I have created. I do not want to repeat the contract number for each asset that falls within that contract number when I display each...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.