Results 1 to 2 of 2
Thread: Table Design (Access 2000)
2003-04-07, 11:16 #1
- Join Date
- Aug 2001
- Cape Town, South Africa, South Africa
- 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)
Table 2 (Payments Schedule)
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
2003-04-07, 12:06 #2
- Join Date
- Mar 2002
- Thanked 30 Times in 30 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.