Hi Bubblers, Happy New Year.
So I am working on a little project for organising my watch collection, and am currently trying to figure out the best way to set up the database.
There will be several users, some of which will have the same watches but will have private info about them such as price paid, price sold, and which watches have been worn on a particular day.
Current Database Setup:
WATCHES
(this will have many fields about the general specifics of a watch, make, model, size etc)
USER
WATCH COLLECTION
I am trying to set it up so the user can select a date from a date picker, select a watch from a dropdown and press a button and add that date to a list of dates within the âWATCH COLLECTIONâ Table.
Having trouble getting this to work. Any Ideas?
Many thanks.