Nested Database Results

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



I have a form with several fields that are fed from database results. The
form is used to update a record in the database. I have a problem where
people are updating records with invalid data for one of the fields. I would
like to use a drop down menu on this field fed from another table in the
database to allow users to pick from a list of valid alternatives to the
data currently stored in the record. This would require datbase results
within database results which doesn't seem to be allowed. Any ideas on a way
to make this work or alternatives? Thanks


.



Relevant Pages

  • Re: Generic Database handling class
    ... looks like th EF needs a database as an input. ... You can mix ORM and non-ORM, ... in ORM's is caching of data in memory. ... up having invalid data in memory, ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Relationships. Does anyone use them?
    ... An application is built to enter data into a database. ... This is extra work that engine-level RI enforcement makes completely ... Secondly, if the second developer misunderstands the data structure, ... database will be completely unable to write or edit invalid data. ...
    (comp.databases.ms-access)
  • Re: Nested Database Results
    ... Microsoft MVP - FrontPage ... > I have a form with several fields that are fed from database results. ... > where people are updating records with invalid data for one of the ... > valid alternatives to the data currently stored in the record. ...
    (microsoft.public.frontpage.programming)
  • RE: TextBox easy lost focus
    ... This TextBox is connected with the field in database. ... LostFocus event to this TextBox. ... database update occurs and give feedback on any invalid data found. ...
    (microsoft.public.dotnet.framework.windowsforms.controls)
  • Re: How I dramatically sped up DB file updating
    ... > Yet, if it takes 28 seconds to update 500 records on a Access database, ... > I do not remember to have found noticeable speed differences when batch ... This approach isn't great...it doesn't give consistent times. ... Prev by Date: ...
    (comp.lang.pascal.delphi.misc)