Base from a table INVOICE I want to lookup names etc. from another table

From a table INVOICE i want to add a client name, telephone, etc. from a CLIENT table. I do not know if this can be done in the table or use a form. I tried using a form and subform but cannot see the fields in the subform in order to select them and have them show up in the main form. I am new to this. please help and maybe refer me to information about this. Thank you, Roberto C

With the documentation there is a database sample used in the Base guides.

LibreOffice Base Documentation

Hola Amigo:

Your reference to LibreOffice Base Documentation is a tremendous help, plus help about different parts of LibreOffice.
I was unable to get beyond Welcome to LibreOffice Help! page (main page), could not navigate to where you sent me. Now everything fine.
It might be a good idea to make it easier to get to where you sent me, from the first welcome.
Soy un total neofito.

Muchísimas gracias y saludos a Ud., con 1719 Answers, y Coruña desde el Lago de Atitlán en Guatemala. Atentamente Roberto Collins Lazo
p.d. si es que debo cerrar esta pregunta, por favor me dice como.

It is better to answer by means of an example. Download Invoicing.odb If it downloads as a .zip change it to .odb.

The Clients Table holds the Client details. The ClientID is an integer Auto Value Primary Key that will increment by 1 when a new Client is added. You would have mode fields here - address etc.

The Invoices Table holds the details of each Invoice. The InvoiceID is an integer Auto Value Primary Key that will increment by 1 when a new Invoice is created. It contains an integer field ClientID which forms the Relational link to the Clients Table. You would have more Fields here.

The Form is based on the Invoices Table with a sub Form based on the Clients Table. The Form and sub Form are linked on ClientID. The Client Column in the MainForm_Grid has been replaced by a List Box. The bound field is ClientID and the displayed information is FirstName, Surname, and Phone concatenated with - between them.

To add a new Invoice click on the Add Record in the Invoices Grid and click in the Client Column, click on the down arrow to the right of the field and it will show all Clients. The Name and Phone should allow you to determine an unique Client. Fill in the rest of the Invoice Fields.

Hi,
I downloaded all the documents about Base as well as the Invoicing.odb , but still…
This is what I would like to do: Start a new invoice: select a client from the client base with a drop down list or the like, which would then include in the invoice information from other fields of the client base or add a new client at that time if possible: select (let’s say) a Tour from the from the tour base with a drop down list:
select (let’s say) a gender button with say tree choices. Thank you, GD