Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Using the CBO method of combo boxes

Discussion in 'Information Technology' started by CSE306, Jul 28, 2006.

  1. CSE306

    CSE306
    Expand Collapse
    Guest

    I used the CBO method to automatically populate the name of our accounts
    based off the of account number we entered. While this works in the form the
    account name does not transfer to the table. Our problem is all of our
    reports pull data from the table based on the account name and not the
    number. Is there some way to get the data to post from the form to the table
    as would normally occur?
     
  2. Loading...


  3. Ken Sheridan

    Ken Sheridan
    Expand Collapse
    Guest

    "CSE306" wrote:

    > I used the CBO method to automatically populate the name of our accounts
    > based off the of account number we entered. While this works in the form the
    > account name does not transfer to the table. Our problem is all of our
    > reports pull data from the table based on the account name and not the
    > number. Is there some way to get the data to post from the form to the table
    > as would normally occur?
     
  4. Ken Sheridan

    Ken Sheridan
    Expand Collapse
    Guest

    Sorry about the blank post!

    You should not store the account name in the referencing table, only the
    foreign key account number, which will be the ControlSource of the combo box
    on the form, and this its value, although it shows the names. To store both
    would constitute redundancy, which leaves the door open to update anomalies
    as it would be possible to have the same account number and different account
    names in separate rows, or vice versa.

    The report should be based on a query which joins the table with the foreign
    key account number (the referencing table), which is the table your report is
    based on at present to judge by what you say, to the table with the primary
    key account number and the account name (the referenced table). You can then
    include the account name in a column in the query and bind a text box to this
    column in the report. The join is made on the account number fields.

    Ken Sheridan
    Stafford, England

    "CSE306" wrote:

    > I used the CBO method to automatically populate the name of our accounts
    > based off the of account number we entered. While this works in the form the
    > account name does not transfer to the table. Our problem is all of our
    > reports pull data from the table based on the account name and not the
    > number. Is there some way to get the data to post from the form to the table
    > as would normally occur?
     

Share This Page