Hello everyone, so this is my first post here and I do hope you can help.
so I am trying to build an application which is using WordPress, buddypress, elementor pro and toolset with the buddyxpro theme.
The app I am trying to build is a hobby manager that will allow you to keep track of stock (Models & Paints), track model builds progress and then manage lore and stories surrounding the models. All while being part of the community via buddypress.
Back before I became disabled was a programmer and would have simply created a table to hold basic model data, table to hold basic paint data, table for brands of paint and model, table for managing stock, table for the model progress track then a group of tables to manage the creation of lore and stories for each model, squad, character etc.
now when I started programming we linked tables by ID each would have the UserID in there to allow for pulling data via sql WHERE UserID = $UID.
I am struggling to pull all the training videos together to work this out, the old brain does not work as it once did, and I don't seem to be getting these post types. its still very new but the toolset documentation is becoming confusing at times.
now I made a couple of post types to store the basic model info though I'm still wondering if I should use taxonomy with custom image to categories the models to their brands.
Next it is the shelf that will hold UID, ModelID and Quantity. this would display front end and allow for more models to be added to the Shelf or increase the quantity of existing shelf model.
next would be the model tracker which would look to the shelf and deduct 1 from quantity and allow a user to update the progress of the build & Paint stage as well as uploading photos to a gallery for that model.
now I know how this would work mysql and php command but in toolset I am becoming stuck in what fields I need to make and how to then link the queries together.
if someone could help flesh out the toolset structure please so I can get the basic part sorted I can then work on the remainder.
Thanks everyone and happy Sunday.