saving records from 2 tables with one to many relationship

[rwahdan1978]

Hi



I have 2 tables (customers and invoices), one customer will have many invoices. In a form I have added the user and the invoice details and I have a button to save the data, how to do that with VBA sql?

Username: ramiwahdan
Invoice#:1234
Date: 17-8-2024
Payment Amount: 200

where username is in one table and others in 2nd table.

[CJ_London]

Which table are you storing username? In the customer table implies all invoices are to be credited to the customer ( but doesn’t look like you specify a customer). If in the invoice table, implies username is the person who entered the invoice

so really not enough information to advise.

[mike60smart]

Can you upload your database?

[rwahdan1978]

Can you upload your database?

Attached is my database

[mike60smart]

Hi

Your Form "Invoice" does not make much sense.

Normal construction is that you would have a Main Form based on your table "Users"
with a subform based on the table "Invoice"

Your table "Invoice" has a PK set as Shorttext and it should be an Autonumber.

You should not be setting a Format on the field "Payment1", this should just be a Currency DataType.