LO Base macros?

Hello,
I’m new user of LO Base, we are transitioning from MS Access, and I need to redesign our db from it. The base contains some VBA macros.

I have read the Book LO Base, and made some tables and forms. I have some difficulties with macro creation.

What I need macro to do? The base is warehouse management tool. I need form that has 3 drop down lists:

  1. Product group select,
  2. Product sub group select (Filter those by group)
  3. Product select (Filter by subgroup)

And one field for insertion of number or items that has to be added/removed.

In form then need add /remove Amount (number inserted in form) of selected product from warehouse.

I have difficulties with accessing the form data. And proper database connection with macro.

Thank you so much.
Best,
Milica

Milica :

What I need macro to do? … I need form that has 3 drop down lists: Product group select; Product sub group select (Filter those by group); Product select (Filter by subgroup); And one field for insertion of number or items that has to be added/removed.

I doubt you need macros for these tasks, just a well-designed database with a properly setup FORM (with list or combo boxes and subforms!