Forms Newbie - 3 tables in 1 form

  • Thread starter Thread starter Pal
  • Start date Start date
P

Pal

Hi guys,

I have this relationship going on with the following
tables:

CompanyTable: CompanyID,CompanyName
EmployeeTable: EmployeeID,EmployeeName,CompanyID
CustomersTable: CustomerID,CustomerName,CompanyID
InvoicesTable: InvoiceID,InvoiceNo,EmployeeID,CustomerID

The relationships are One to Many for:
CompanyTable to EmployeeTable
CompanyTable to CustomerTable
EmployeeTable to InvoicesTable
CustomersTable to InvoicesTable

The relationships have Referential Integrity + Cascade
Update Related Fields + Cascade Delte Related Records for
all.

Now when I go to create an Invoice form with all the
entries from all the tables (With the exception of the
IDs), I can input entries in the CompanyName,EmployeeName
and CustomerName fields, but can NOT input anything in
the InvoiceNo field!

Why is this happening?!

Thanks for any help
 
Now when I go to create an Invoice form with all the
entries from all the tables (With the exception of the
IDs), I can input entries in the CompanyName,EmployeeName
and CustomerName fields, but can NOT input anything in
the InvoiceNo field!
Click to expand...

DON'T try to create One Big Master Query to do everything - it won't
work. Instead use Subforms and Combo Boxes (lookups, but don't use the
table lookup field).

I'd suggest a Form based on Companies, with a Subform based on
Invoices. This subform could have combo boxes to enter the EmployeeID
and the CustomerID. Other arrangements of subforms may fit your needs
better, but they're the way to go.
 
Back
Top