Data concept

I am pretty green when it comes to databases. I am trying to create a VB
program to pull from an Access DB with multiple tables. Say I have 2 tables
in a database, table 1 is for parts and 2 is for some kind of features of
the parts. So for each part there will be many features. When you add a
feature it will just add on to the end of the features table so they are not
all grouped together as far as which part they are related to goes.

Then if I want to use a Dataset in VB to hold the data I'm working on then I
don't pull the whole table but instead the data related to the part I'm
working on, right? But then if my program adds a feature, you can't just
tack it on to the end of your dataset table, because it doesn't know where
the real table ends. So do you just add it to the dataset and then when you
update back it knows where to put the new data, or do you connect and add
the feature and then pull the new back into the dataset?? Or maybe you just
grab the whole features table? But if you do that what if someone else has
already added a feature with that ID?


.

Relevant Pages

  • Re: WOTT - Folder Features
    ... What are your favorite features, or those features you consider most ... FREE historic Western Martial Arts manuals:http://www.lulu.com/lawson ... course those little pull out grooves. ...
    (rec.martial-arts)
  • Re: tilia food saver
    ... power.......I call the head office and they say all pull the same ... amount of air per second....short of having all the added features and ...
    (rec.food.cooking)
  • RE: Need Help on "Yes/No" Query
    ... change the Criteria field under each feature to say "Yes" and ... > I need to run a query that will pull ONLY the Features ...
    (microsoft.public.access.queries)
  • MS Outlook Express 5.0.6
    ... I am using OE 5.0.6 with Mac OS 9.1. ... From the pull down menu, ... the features are shaded such that we cannot select and use them. ... Mike Waage ...
    (microsoft.public.internet.outlookexpress.mac)
  • Re: SQL
    ... >My point is that these features are useful non-persistence features ... >organization of data according to the relational model. ... appropriate data in the RDBMS. ... >> Do you have any examples of relational databases that have specific features ...
    (comp.object)