How do I put a table on a form?

[Barnie]

I am trying to put columns from a table onto a form so I can enter data
directly onto the table through the form. I have two tables, one is for
client details and the other invoice details. I am trying to do one form
where I can enter the clients communication details to update the contact
table but I want to be able to enter multiple invoice details all on the same
form without having to enter them one at a time. Can anyone help?

 

[BruceM]

You can't put a table on a form. In any case, tables are not meant for data
entry. You can make a form resemble a table by using the datasheet format.

It is not clear what you are tyring to do. Typically one client can have
many invoices, and one invoice can have many details. There would be a
table for Clients, Invoices, and InvoiceDetails. Also, if there is a
connection between invoices and employees you will want an employee table.

tblClient
ClientID (primary key, or PK)
ClientName
Address, etc.

tblInvoice
InvoiceID (PK)
ClientID (foreign key, or FK)
EmployeeID
InvoiceDate
EmployeeID

tblInvoiceDetails
InvoiceDetailsID (PK)
InvoiceID (FK)
Description
UnitPrice
Quantity

tblEmployee
EmployeeID
FirstName
LastName
etc.

The tables are related one-to-many: tblClient >> tblInvoice, and tblInvoice
There are other possible tables. For instance, if there is a standard list
of items that could appear on an invoice, those need to go in their own
table. Further, since in that case one item could be part of many invoices
and one invoice could contain many such items, a junction table is needed to
resolve the relationship. I have not shown any of that in my sketch of the
table structure. For one thing, I don't know the nature of the real-world
problem you are trying to solve, so details are speculative.