Editing Table by using relations...

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • savas_karaduman@yahoo.com
    #1

    Editing Table by using relations...

    Imagine two tables. One is T_Tender, other T_Material
    T_Tender fiels: TenderNo, TenderName
    T_Material fields: MatrNo, TenderNo

    There is relation across TenderNo between two tables. I would like to
    simply show TenderName in the table T_Material, rather than TenderNo.
    But access should use TenderNo for that entry.

    I am finishing now. My target actually to enable the user to edit
    TenderNo for T_Material table using a form. Instead of TenderNo,
    TenderName should be visible there to make the user job easier.

    Will be appreceated for any help.

    Tags: None
    • tina
      #2
      Re: Editing Table by using relations...

      use a combo box control in your form. use the following property settings
      for the combo box, as

      ControlSource: TenderNo
      RowSourceType: Table/Query
      RowSource: T_Tender
      ColumnCount: 2
      ColumnWidths: 0"; 1"
      BoundColumn: 1
      ListWidth: 1.25"

      adjust the *second* number in the ColumnWidths, and adjust the ListWidth, as
      needed, so that the full TenderName values show in the droplist.

      recommend you read up on combo box controls, and their properties, in Access
      Help, so you'll understand how they work.

      hth


      <savas_karaduma n@yahoo.comwrot e in message
      news:1164024424 .246847.278420@ b28g2000cwb.goo glegroups.com.. .
      Imagine two tables. One is T_Tender, other T_Material
      T_Tender fiels: TenderNo, TenderName
      T_Material fields: MatrNo, TenderNo
      >
      There is relation across TenderNo between two tables. I would like to
      simply show TenderName in the table T_Material, rather than TenderNo.
      But access should use TenderNo for that entry.
      >
      I am finishing now. My target actually to enable the user to edit
      TenderNo for T_Material table using a form. Instead of TenderNo,
      TenderName should be visible there to make the user job easier.
      >
      Will be appreceated for any help.
      >

        Comment

        • Darryl Kerkeslager
          #3
          Re: Editing Table by using relations...

          It sounds like what you want is a combo box on the form, with its Row Source
          being, "SELECT TenderNo, TenderName FROM T-Tender ORDER BY TenderName"

          The number of rows would be 2, the bound column would be 1, and the first
          width of the first column in the Column Width property would be set to 0
          (0";2" for example).

          The Control Source would be TenderNo in table T_Material.

          --
          Darryl Kerkeslager
          <savas_karaduma n@yahoo.comwrot e in message
          news:1164024424 .246847.278420@ b28g2000cwb.goo glegroups.com.. .
          Imagine two tables. One is T_Tender, other T_Material
          T_Tender fiels: TenderNo, TenderName
          T_Material fields: MatrNo, TenderNo
          >
          There is relation across TenderNo between two tables. I would like to
          simply show TenderName in the table T_Material, rather than TenderNo.
          But access should use TenderNo for that entry.
          >
          I am finishing now. My target actually to enable the user to edit
          TenderNo for T_Material table using a form. Instead of TenderNo,
          TenderName should be visible there to make the user job easier.
          >
          Will be appreceated for any help.
          >

            Comment

            Previous template Next
            Working...