

- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
A table view that allows the user to draw simple shapes and place them to form a layout, and then place records in those places. Starting with a simple gridded background (i.e. like graph paper) place a circle or a rectangle in the grid and then connect that shape with a record in the table, or perhaps a query of the table.
In my particular situation, Iโm working on a winery production database that will keep track of wine lots and barrels and tanks. A common way of managing tanks is to use a whiteboard with circles in permanent ink drawn on the board to represent the tank layout in the tank room and then use white-erase pen to write in the lot and date of fill and planned date to empty. This is a similar problem to POS systems in restaurants, that have a view where you can draw simple circles or rectangles to represent tables and keep track of seating and reservations that way. A manufacturer with process flow or a warehouse with stocking will have similar needs. You could use this kind of view for a seating chart or for an office inventory as well.