Ask Your Question
0

Creating a new related record

asked 2019-07-01 14:57:15 +0100

Hello everybody,

Let's say I have a table named Clients and an other one named Invoices which are related (but it could be anything like Director/Movie, Patient/Consultation...)

I want to be able with a button to create a new invoice when I'm in any record of the table Clients. How do I proceed : is there a LO buit-in way of doing so or do I have to create a macro or anything else ?

Thanks

Pascal from France, on a Mac

edit retag flag offensive close merge delete

Comments

Hello,

Please when posting, include specific LO version being used and in the case of Base, the database in use (HSQLDB embedded, Firebird embedded, MySQL PostgreSQL etc).

Ratslinger gravatar imageRatslinger ( 2019-07-01 15:28:24 +0100 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2019-07-01 15:35:37 +0100

Ratslinger gravatar image

Hello,

You really don't need a button or macro to run a report based upon a particular record (Client). This can be done with a parameter in a query. Much of this is in the LO documentation found here -> LibreOffice Base Handbook.

If you insist on this button method, then you would need to use a macro. Macros need specific information. Details from various parts of the Base file so specifics cannot be presented. However here are posts, including samples, which are related:

How to use a form button to open a report

Create report based on inputs of current form - LO Base

edit flag offensive delete link more

Comments

Hello,

Thanks for your help, I'll look at the documentation and do my best.

Pascal

Mac Mojave, LO Version: 6.1.5.2, HSQLDB embedded.

PascalH72 gravatar imagePascalH72 ( 2019-07-01 22:42:27 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-07-01 14:57:15 +0100

Seen: 23 times

Last updated: Jul 01