My first project

Hello Andy 2020

Welcome to MVD
Give us more details on the goal of your project:
- Do you want to make a sales/purchasing program like a commercial program?
- Do you want to add an inventory management part (inputs/outputs) as sales progress (alarm thresholds, supplier management, etc.)?
- Do you also want to have invoice management (issues, storage)?
- Do you want to plan a reminder section for customers (via email)?
You see, there are plenty of possibilities to develop what you want to do.
In most cases, MVD is able to achieve what you want to do.
But you need to give us more details.
Give us a detailed overview of each of the functions you want implemented.
There we can help you better
Sincerely
J.B.

Hello andy2020

Obviously, you will end up creating a fairly complex program.
So, you should not jump straight into MVD.
On a sheet of paper (I know, I'm an old-school programmer), you plan each element of what you envision:
- Purchasing part (net cost, VAT, total cost, etc.)
- Management of your stocks (entries, exits, alert threshold, etc.)
- Sales part (cost details, excluding tax, net sale price, VAT to apply (several possible rates)...)
- Invoicing to follow (therefore creation of a customer file, reminder emails, direct link with Paypal or any other invoicing system)
- Monitor your current sales...and I'm probably forgetting some.
So first thing to do (on paper):
- Create your tables (Customers, suppliers, products... which fields? with Calculated fields? with Password? With Roles? ...)
- Choose your fields carefully (simple, associated with others, obligatory? ...)
It's going to be a complex project, by anticipating it on paper, you'll see what you need and what you can eliminate.
Nothing is more annoying than having to constantly restructure your tables directly on the computer, when everything is anticipated, there are many fewer unpleasant surprises later; an unforeseen modification in a table can force everything to be recalculated with the risk of crashing.
As you can see, you still have a lot of work to do and if you also don't master MVD (and SQL because you can't escape it to automate functions), good luck!
Tell me what type of product you want to work on for your sales, I will try to start working on this project starting from what you want.
J.B.

Hi Andy2020, Salut Jean - ça va ?
I can only reiterate what Jean is saying - this appears to be a fairly complex project and not one that you would typically choose when starting out with MVD (or any other product that you might use).
Personally, I would suggest breaking down your total requirement into discrete processes and then just select one of them as a way of familiarising yourself with MVD.  Even if you end up scrapping it, it will be a good learning curve.
Attached is an old program that I've altered to fit some of the things you've mentioned (receiving products into stock from suppliers and then issuing them to customers) that might give you some ideas of the sort of things you can do even with 'basic' MVD.
Derek.