Where can I find information on how to create macros in base?

Where can I find information on how to create macros in base? I formerly used Approach as a database tool and macros were very easy to create. I note that in Forms of L.O. Base there is the possibility to insert macros. Perhaps someone can tell me where I can get more information on this, and give the example of a simple macro that one might create. For example to automatically fill in a field with two elements of data from two other fields (e.g. CITY and the last three of STATE to fill in another field CITYSTATE, using a button on a form.

The first is from The Document Foundation: click here. Chapter 9 is a starting point for macros and has many examples. The most complete reference/guide in one document is Open Office Macros Explained (OOME) by Andrew Pitonyak (click here). You can download the PDF version there.

The last edition of Pitonyak’ “Bible” is here: http://www.pitonyak.org/OOME_3_0.pdf