Example: Generate all combinations of values
This example demonstrates how to generate records that contain all possible combinations of two or more values.
Description
This example shows how to generate bookings for participants. Each participant could have bookings for several weeks. Instead of manually creating all the records, simply select the participants and the weeks so that all the bookings for each combination would be generated automatically.
Another example where this could be handy is generating the records for the clothes in stock. Let’s say you have blue and yellow jackets in sizes S, M, L. You want to generate the records for all the possible combinations.
We will demonstrate the settings using the booking example. Check the detailed description in the blog article.
Screenshots
To help you make the system work for your needs, we have developed the following service program:
- Discuss your needs with our staff.
- We’ll determine and confirm the workflow logic of your database.
- We’ll create a ready-to-use database to fit your exact business model.
- You’ll get a solution designed especially for your needs.
Any support materials, such as spreadsheets and real-life work samples would be very helpful as they would help us better understand your business process.
We offer free system configuration assistance
(up to 4 hours of consulting work).
If you decide that our database is not exactly what you need - you owe nothing.