I require to be able to print out a carrier schedule which consists of up to 4 premises and a consignment numbers in a specific layout on the printed page.
The premises are held in an address table and the consignment numbers are held in a consignment number table.
There is no relationship between these tables (until the carrier schedule needs printing).
When the carrier schedule is to be printed, the user wants to select up to 4 premises from the address table, each of which needs to be positioned in a specific area of the page, and one consignment number which needs to appear in various specific areas of the printed page.
How do I tackle this problem? Is there some combination of queries, forms or reports which can do the job? Any help whatsoever would be much appreciated.
The premises are held in an address table and the consignment numbers are held in a consignment number table.
There is no relationship between these tables (until the carrier schedule needs printing).
When the carrier schedule is to be printed, the user wants to select up to 4 premises from the address table, each of which needs to be positioned in a specific area of the page, and one consignment number which needs to appear in various specific areas of the printed page.
How do I tackle this problem? Is there some combination of queries, forms or reports which can do the job? Any help whatsoever would be much appreciated.
