We have a staff sales database in Notes 4.6.2 which contains the catalogue information (imported from Excel) for all items available to purchase by staff. Each item is a separate document. Every 3 months or so, all merchandise is deleted and the new catalogue is imported.
The users have a personal folder called "Shopping basket" and they move items they want to this folder.
We need to allow the users to select up to 10 documents in the shopping basket and create a new document summarizing the details from the selected documents in a printable order form format. The users should select the documents to order, preview the form, then either cancel or confirm. When they confirm the order, the order form would be saved.
The administration will also need a view in which they can list by item the number of users who have ordered it.
Design suggestions on the best way to handle these requirements, and code (if necessary), would be welcome.