Steps for a Database

[Bikerman]

I am not new to access but I am having some problems with a design of my own.
Can some one explain the basics behind on how to generate a database where there is a "tblCustomers", "tblProducts" and "tblInvoices". I don't need to know how to make the tables!! I just kind of get confused with the relationships and how to be able to enter multiple invoices for a specific customer. I also need to know how would I go about selecting the customer from a list. I hear so many bad experiences with look up fields on forms.
Will be greatly appreciated.
Jose Ricardo in Ft. Lauderdale Fl.

 

[Duane Hookom]

Have you looked at the same Northwind.mdb? Also, there is nothing wrong with
using combo boxes (lookups) on forms. Many of us find using lookup fields in
table designs ill-advised.

--
Duane Hookom
MS Access MVP

I am not new to access but I am having some problems with a design of my own.
Can some one explain the basics behind on how to generate a database where

there is a "tblCustomers", "tblProducts" and "tblInvoices". I don't need to
know how to make the tables!! I just kind of get confused with the
relationships and how to be able to enter multiple invoices for a specific
customer. I also need to know how would I go about selecting the customer
from a list. I hear so many bad experiences with look up fields on forms.