Re: [libreoffice-users] Concatenating fields in related form

Hi Adam,
> 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.

Regards

Robert
-- 
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy