Enter Into Sub-Datasheet

skea

skea

Registered User.
Local time
Today, 03:13
Joined
Dec 21, 2004
Messages
342
Back again. Is there a way can i get VB.NET related tables act like the Access
main to subdatasheet entry format. I need to manually enter related records into a foreign table but i cant get going. Any Idea.
I am using MSDE for the moment and i have related my two tables.
 
I am too looking into this... and this is going to be a quick reply and hopefully Kodo or someone else will expand on this for us.

I have found a few resources on this and one quick one is here:

http://ssw.com.au/ssw/Events/2005AccessToSQLServerAndNET/resources.aspx

Take a look at "How to Migrate Access forms... " that will show one way on how to use a datagrid for your related table. Evidently there is no support for subforms in .NET.
I believe I have seen other examples using the CurrencyManager and binding it to the main table of the DataSet.
 
I didn't follow WindSailor's link. .given that , I would say (off the top of my head) to try using the binding source object and bind your text fields to the the values of your returned data for the "parent" form (i have a demo of that piece in the vb.net forum here). The next part would be use , maybe a gridview that rebinds it's data based on the "main" forms datakey..probably the ID of the record which is the foreign key of the sub records.
If I have time later, I'll do a demo for you.
 
Thanks, but i think you both lost me.
What i mean. When you relate two tables in access, you get a node(+) sign on the primary table. With this, one can navigate a record in primary table to the related record in the table that contains the Foriegn field.
I usually do this in access when manually inserting data for testing my application. I now have MS-SQL 2000 Server but i also dont see the feature when i relate my tables.I have tried to create a diagram for the related tables but i cant see any thing! What do u guys do??

I am sorry,i should have posted this in the SQL-Server forum but its too late.
 
Last edited:
did you enforce referential integrity?
 
You must log in or register to reply here.

Similar threads

D
After update
Replies
17
Views
481
Pat Hartman
P
D
Hello out there!
Replies
17
Views
441
Davebert
D
C
Change the Sub-Form View by using VBA
2
Replies
21
Views
927
Uncle Gizmo
Uncle Gizmo
B
Expanding related tables and splitting database
Replies
10
Views
388
Pat Hartman
P
D
Help with simple design
2 3 4
Replies
64
Views
1,508
Davebert
D

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom