Re: Multi column Combobox

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

>Does the Account Analysis Input Table really have only one record per
>client, as is implied by its having [Client Name] as its primary key?
>If so, there's no reason for [AA Client List Table] to exist. What sort
>of information goes into [Account Analysis Input Table]?

The Account Analysis Table will hold mutiple records for each of the 32
Clients. *Some of the Clients share Account #'s.* I see how that eliminates
the Primary Key for those two fields. Of the 32 Client's, 31 have individual
Account #'s with, for example, Belk #1 and Belk #2 sharing an Account #. I
will be entering the data for all 32 Clients.

The AA Client List Table exists so I could create a combo box with a drop
down arrow so I can select the 32 clients from that list. Is there a better
way to create a list of clients in a form to pick from?

I need to duplicate data becaues each client will be making entries into this
table and it's possible that every field could contain duplicate data. With
that being said, I don't have a Primary Key. Is this a bad thing?

-Charles-


--
Message posted via http://www.accessmonster.com
.

Relevant Pages

  • Re: Search or filter form and subform
    ... You could use a subquery in the form's filter. ... The structure you have makes sense if all your clients are companies, ... Primary key: ... History -- records of instances of communication, no primary key, linked ...
    (microsoft.public.access.forms)
  • Re: Search or filter form and subform
    ... So you want to provide a text box where the user can enter part of a name, and the filter the main form so it contains only those companies whose name matches, or those companies who have a related contact whose name matches. ... The structure you have makes sense if all your clients are companies, i.e. you never sell to sole traders or individual persons. ... Primary key: ... History -- records of instances of communication, no primary key, linked to ...
    (microsoft.public.access.forms)
  • Re: Another design advice
    ... I have a table called iClientSupplier. ... clients, suppliers, and warehouses for my inventory control system. ... the primary key needs not change ever. ... >> primary key is an autoincrementing field without any meaning, ...
    (microsoft.public.sqlserver.programming)
  • Re: query error
    ... linking the Primary Key value (which might be of any datatype, ... in the Clients table you would have a Number... ... You might want to take a look at some of the database design tutorials in the ... The Access Web resources page: ...
    (microsoft.public.access.queries)
  • Re: Design Problem
    ... > for clients). ... > not a family member (only name and contact information is collected ... ContactID PRIMARY KEY ... BelongsTo FOREIGN KEY REFERENCES Contacts ...
    (microsoft.public.access.tablesdbdesign)