Link info in multi. forms in Base?

[Branmufinn]

How do I link multiple information in multiple forms? I want to have a parent form and 2-3 other forms that have some of the same information.

We used Lotus Approach before and had one-to-many relational joined databases. They is what I need to recreate. I thought Libreoffice Base could be set up that way, but I’m having a very difficult time setting it up.

More specifically, we have many clients so the main database contains their information. Then we have another form for service information specific to that client (again some information is the same as the main form but not all). We also have another form for inspection reports (again some information is the same from the main form, but not all).

How do I create this using LibreOffice Base? If it is not possible (which I’m start to think) then I will be moving to Excel.

[frofa]

Branmufinn:

More specifically, we have many clients so the main database contains their information. Then we have another form for service information specific to that client (again some information is the same as the main form but not all). We also have another form for inspection reports (again some information is the same from the main form, but not all).

The core concept to let you do what you want is to store the ID of the target-client in a FILTER TABLE. The idea is that the user chooses the CLIENT NAME from a drop-down list on your main form, and once confirmed, the client ID (integer value) is written to the FILTER TABLE. All other client forms use this value to show the relevant client information. NOTE: the user only needs to select the client name from the drop-down ONCE, after this all your ancillary forms will show the correct information. However, for convenience, there is no reason why you can’t have a client-selection drop-down on ALL your forms, so no matter which form you open you may then set the target-client.

See the link following for some guidance on how to setup a FILTER TABLE in conjuction with FORM-BASED FILTERING.