I can only get this to work (with a list box) if there is only one
project for each client. If I have two separate project records with
the same client id I get an error.
There must be something wrong in your database-construction. Please load
up an example with some dummy-data to see what is getting wrong. If you
couldn't load it up anywhere please send the example direct to me so I
could see the problem, which appears.
But: Do you really know all ClientIDs? I would prefer a listfield
instead, which directly shows the names.
I have nearly 1000 clients. It would be tedious scrolling through
those looking for a client, or am I missing something? I was hoping I
could recreate my old Filemaker method of linking the records.
Alex has already send an answer to this. It is no problem to type a
ClientID in a field, press a button and see all rows of the database
with this ClientID.
LibreOffice Community: http://robert.familiegrosskopf.de/map_3
To unsubscribe e-mail to: firstname.lastname@example.org
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy