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+unsubscr...@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