LibreOffice Base - Multiple Pages Record w/One Form?

[duckb00ts]

Does anyone know how to create a multiple pages form associated with one record?

For example, this one record would include Project Info (on one page/screen, Page 1) > Customer Info (on one page/screen, Page 2), Employee Associated w/project info (on one page/screen, Page 3), and Vendor associated w/project Info (on one page/screen, Page 4), which is all associated with one record.

I’ve been trying to figure this out for several days, but have been unsuccessful in doing so. Any assistance that you could provide, is highly appreciated. Thanks!

[frofa]

I am not sure why you would want to do this division into 4 separate forms/pages to show related data for each PROJECT. Depending on how many data FIELDS you want to display, it might be possible (and simpler), with careful form design, to fit all the information you need into a single FORM/WINDOW.

Assuming that all the information you need is ‘spread’ over several TABLES, you would need a QUERY (or several QUERIES) to provide all the information required to show on your set of FORMS/WINDOWS (a subset of information would need to be chosen for each of them).

You would also probably need to use a FILTER TABLE to store the PROJECT ID which I am assuming is the KEY that links together all other associated information such as about associated EMPLOYEE, CUSTOMER, VENDOR, etc. Once the FILTER value is set, that PROJECT ID value is used by the relevant queries and FORM setup to display the correct information on the separate forms.

Since you haven’t described your Database DESIGN/SCHEMA, I am assuming a 1:1 relationship here (which may turn out not be the case and if so, will make things more complicated).

NOTES: The above is just a sketch, since (as stated above), we don’t know anything about your DATABASE DESIGN/SCHEMA.

[gkick]

Hello,

You can have multiple table controls on a form as per image below

An alternative which will require macros are to use form sections, see

Tabbed forms within a Main Form

Is it possible to create tabbed forms within a main form in LibreOffice Base? I have created a similar form in MS Access. I would like to repeat a similar form in LibreOffice. Thanks in advance for the help. – Bhat59 (I tried to upload an image but it says >3 Points required to upload files)

how to create a form with sections

I’d like to add sections in a form and use buttons to switch from a section to an other. Supposing to have a form called FORMULARIO and 4 sections called UNO, DUE, TRE and QUATTRO, how do i make it work? Searching in the internet i found this macro and seems to be similar to what i need, but it was not provided of comments and so, i don’t know how to custumize it, nor i’m able in write a macro by myself. Any help? sub PysAfficher(PysEvent) dim i as integer for i = 0 to thiscomponent.Text…

Another way is to layer the table controls on top of each other and either use buttons or a listbox to toggle visibility between them.

[duckb00ts]

How would I go about layering the table controls on top of each other and use buttons or a list-box to toggle the visibility between them? This method seems doable, especially for a super-newbie like me. Thanks.

[gkick]

Here is one example, however it also requires macros.

Create a macro in odb to change a table in table control

Hi all there. I have to do a certain task, that would otherwise not require this, but it’s asked anyway. The task is to create a form, in which the user can check the data of a table and modify the contents of that table through buttons, and therefore, I need to write the macros that affect the table control element in the form and more specifically columns. To be more precise I have to create buttons to: 1-Change all the values of a column of the table from S to N(and would be very nice …

However, since you are a new to base - you may want to opt for simplicity first as the more complex a solution the more can go wrong.