Ask Your Question
0

Link info in multi. forms in Base?

asked 2015-12-04 00:34:27 +0200

Branmufinn gravatar image

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.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2016-01-03 00:23:06 +0200

frofa gravatar image

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.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2015-12-04 00:34:27 +0200

Seen: 101 times

Last updated: Jan 03 '16