Re: subform/unique records

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

From: tina (nospam_at_address.com)
Date: 05/20/04

  • Next message: Jeff Conrad: "Re: Close the Property (F4) window with code" 
    Date: Thu, 20 May 2004 20:13:38 GMT

    look at the ControlSource property of the Products combo box. it should show
    the name of the Product field in the form's underlying table.

    hth

    "TRM" <anonymous@discussions.microsoft.com> wrote in message
    news:fdb601c43e9a$49c63a30$a401280a@phx.gbl...
    > I have a subform set up as a datasheet. Some fields are
    > set to defaults and are combo boxes. A company has a
    > contract number - this is the link field. An order for a
    > product is made under that contract - there may be
    > several orders but for different products. We have a
    > record for each product (this is the combobox); somehow I
    > have changed something which causes all the records to
    > change if/when the product is changed. Any ideas as to
    > what this might be? THANKS!

  • Next message: Jeff Conrad: "Re: Close the Property (F4) window with code"

    Relevant Pages

    • Re: composed foreign key question
      ... > alter table underlying add ( ... > contraint pk_underlying primary key (contract, ... The problem is I can't create a foreign key on the ... references underlying ...
      (comp.databases.oracle.server)
    • Re: composed foreign key question
      ... natural keys vs surrocate PKs ... So the combination of contract and lookupdate is the only way to uniquely identifying the underlying for an option. ... if it is a true dependent table, determine what would be most appropriate for the 2nd element of the PK -- likely it will also be a system-assigned ID of some sort. ...
      (comp.databases.oracle.server)
    • subform/unique records
      ... I have a subform set up as a datasheet. ... set to defaults and are combo boxes. ... contract number - this is the link field. ...
      (microsoft.public.access.formscoding)
    • RE: Question about Implements
      ... indicating that you are fulfilling ... the contract with the interface ... HTH ...
      (microsoft.public.dotnet.languages.vb)
    • Re: Sky HD from eBay
      ... first year of new contract you are obliged to connect to the phone line ... annual term does not apply as it has to be connected for the duration. ... Vass ...
      (uk.tech.tv.sky)