Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Aug 2001
    Location
    Cape Town, South Africa, South Africa
    Posts
    399
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Table Design (Access 2000)

    I have a table with all cheque payments from suppliers and a table of detail of the payment which Invoices was paid with the cheque example:

    Table 1 (Creditors Payment Details)
    CredCheqID
    CredCheqAmount
    CredCheqDetail

    Table 2 (Payments Schedule)
    CredSchedID
    CredCheqID
    InvNo
    Amount

    No I need to link these table in order to run a report to list per Creditor a Payment and schedule if avialable.

    Thanks for the assistance

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Table Design (Access 2000)

    Create a query and add both tables.
    Link them by dragging CredCheqID from Table 1 and dropping it on CredCheqID in Table 2.
    Double click the link (the line between the tables) and click the option to return all records from Table 1 and related records from Table 2.
    Add the fields you want in the report to the query grid.

    You can create the report using the Report Wizard - it will let you decide how to group the report - or design it yourself. In the latter case, group on CredCheqID.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •