Hi Adam, > I have a Client form with ClientID, FirstName and LastName fields and > a Project form with ClientID and FullName fields. In Filemaker I was > able to type in a client id into the Project form and it would insert > the first name and last name from the Client form into the FullName > field of the Project form. How can I do this in Base?
In databases values shouldn't be duplicated. So "FirstName" and "LastName" from one table shouldn't be "FullName" in the same or another table. You will get this values through the primary key and a query. I you want to show "Name" in one field you have to concatenate it like SELECT "FirstName"||' '||"Lastname" FROM "Table" 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. But: Do you really know all ClientIDs? I would prefer a listfield instead, which directly shows the names. 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