A new table has been added to KitBase 2, allowing paint stock (and similar items such as thinners) to be recorded.
The table will be added in to your database when you upgrade to KitBase 2. As you can see from the screenshot below, KitBase 2 now has a tabbed setup showing the different main tables automatically when you open the database.
The approach I have taken for stock quantity is 'Containers in Stock (Full)', indicating how many bottles/tins you have unopened. This is backed up by a 'Containers Half Used' number, indicating the number of tins/bottles with half or less paint left.
A 'Containers Wanted' field is also provided, so that you can flag the paint you need for upcoming builds.Stock List
The screenshot below shows the form and the stock list.Equivalent Colours
Fields are also provided to specify 'Equivalent' colours from different manufacturers and standards, e.g. Equivalent Mr Color.
This screenshot shows paints by 'GSI Creos' number, the common paint numbering system used on many Japanese kits.
As with other tables in KitBase, you can customise the table, form design and views. You can easily add more 'Equivalent' columns to satisfy your requirements.
I have considered more complex solutions, allowing paint requirements to be recorded against kits, so that stock can be looked up automatically.
I'm not sure how many folks would want to fill in that level of detail, therefore I have kept it simple for this release.Feedback and Comments Appreciated.