So I was working on inventory app all looked good until I realised I messed up
I have 2 tables
1- Event list (Starting Date, Ending Date, ID)
1- Kit inventory (List of equipment, {Name, Category, Starting Date, Ending Date, Event ID)
The idea is we will have events planned ahead. I have a screen for the user to create events.
Then equipment is assigned to the events. Currently being patched so Event ID and Start and End are patched from the Event list to the Kit inventory.
That tells me for what its assigned to and whether its available to be booked again. I have the filter bits (toggle become locked) working so the user is not able to double book.
However now I realised using this method I can't book the same kit item for multiple upcoming events which has made my efforts so far pointless. As I have now no clear idea on how to do it in a different way or if its even possible.
Any suggestions would be greatly appreciated.
Thanks
