Thank you for taking the time to reply Robert.
> If you will see this directly while input of values you have to set the > input of "ClientID" in the mainform and the query for the shown content > in the subform. "ClientID" will be the field connecting to the subform. > It could be set up as a listfield with the code > SELECT "FirstName"||' '||"Lastname", "ClientID" FROM "Table" > So it will show the "FullName" if the clientID is submitted from the > mainform. 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. > 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. Thanks, Adam -- To unsubscribe e-mail to: [email protected] 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
