In Herb 50 Accounts the Customers and Invoices tables are separate tables, but they are related because they both include customer account numbers.
You can connect the tables by using a join on the account number. For more information, see Join tables.
|
Account Number |
Name |
Credit Limit |
|---|---|---|
|
2706 |
Dodd Ltd |
£12000 |
|
1302 |
Gatens Inc |
£50,000 |
|
Invoice Number |
Amount |
Account Number |
|---|---|---|
|
44621 |
£2000 |
2706 |
|
44622 |
£15,000 |
1302 |