Re: Multi column Combobox

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

>Further, you should remove the [Client Account #] field from that table.
>This field is specific to the client, and is not dependent on any other
>field in [Account Analysis Input Table] except the [Client Name]
>field -- it's always the same as the value stored in the [Client Account
>Number] field of the record in [AA Client List Table] that has the same
>[Client Name]. Instead of copying this field into the [Account Analysis
>Input Table], base all forms and reports that need the account number on
>a query that joins the two tables. Such a query might have SQL like
>this:
>
> SELECT
> [Account Analysis Input Table].*,
> [AA Client List Table].[Client Account Number]
> FROM
> [Account Analysis Input Table]
> INNER JOIN [AA Client List Table]
> ON [Account Analysis Input Table].[Client Name] =
> [AA Client List Table].[Client Name];

The table is at work and I can't access it at home, but I'll give it a shot
on Monday. Thanks for your patience and guidance.

-Charles-


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200509/1
.

Relevant Pages

  • Re: DBMS and lisp, etc.
    ... Naively implemented with SQL, again for 10 ... (1 query for the initial orders, 1 query for each order for its ... soon as you upgrade to the SQL database. ... (eq (order-customer orderA) ...
    (comp.lang.lisp)
  • Re: How to populate a list box based on user input?
    ... associated with that account pop up in a list box. ... click "View" and a query come up showing all those orders on separate ... I get stuck on what the SQL should look like in the Control Source ... Private Sub txtAccountNo_AfterUpdate ...
    (microsoft.public.access.modulesdaovba)
  • Re: Populating a list -- table structure?
    ... I had made a report already and figured out about adding the ... your responce below, but thanks to your help with SQL, I was able to get the ... It takes a summary from a select query and gives the ... KitID, long integer ...
    (microsoft.public.access.forms)
  • How do I do Paging through a large dataset via Stored Procedures
    ... Paging by dynamically altering the SQL Query ... Create stored procedures ... SELECT * FROM STUDENTS ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Permutations - 8 columns
    ... In that case I might still suggest SQL, but in your case use the Excel ... SQL driver and run the query on your extracted data. ... Dim rs As ADODB.Recordset ... > and multiple reports need to be run to see ...
    (microsoft.public.excel.programming)