Re: Nested Database Results

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



This article: How to filter a database query by using a drop-down list
http://support.microsoft.com/kb/235554 may help you get started

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx


Henry <henry.brummitt@xxxxxxx> wrote:
> 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)
  • Nested Database Results
    ... I have a form with several fields that are fed from database results. ... people are updating records with invalid data for one of the fields. ... database to allow users to pick from a list of valid alternatives to the ... Prev by Date: ...
    (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: Selective Database Results hurdle
    ... I would still avoid using the AutoNumber field type for this, however don't remove it from your ... I do not work with the FP database components, I write all of my ASP code by hand, so if you ... FrontPage Resources, WebCircle, MS KB Quick Links, etc. ... within my dropdown submittal form and the values for that list currently contain spaces and commas. ...
    (microsoft.public.frontpage.client)