Steps for a Database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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


Bikerman said:
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
Click to expand...
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.
 
Back
Top