Form construction

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

Guest

I am trying to construct a form where:

Name, Date, Product, Unit_Price, Qty

are entered into a table.

However, the amount of products that people order are in the tens and
twenties so I don't want to keep re-entering the name everytime I enter a new
product.

Is there a way to create a form where you can enter the name, date, and
product, like this:

name, date
product
product
product

and have the resulting row in a table that looks like:

name, date, product
name, date, product
name, date, product

please advise.
 
Your database design is seriously flawed. You can do this fairly
easily in a properly designed database.
 
You should use one table for Customers (CustomerID, CustomerName), one
table for Products (ProductID, ProductName, Price) and one for
Transactions (TransID *should be an AutoNumber field*, TransDate,
CustomerID, ProductID, Quantity). You can use a continuous form as a
subform to allow multiple entries directly into the Transactions table,
and display the CustomerName on the main form (link the parent/child
forms by CustomerID).

There may even be an easier way to design the form, I'm shooting this
off the top of my head after a night of heavy drinking. Certainly the
database layout I've suggested is more stable and allows for expansion.
 
thank you, that makes sense and is very helpful.

ManningFan said:
You should use one table for Customers (CustomerID, CustomerName), one
table for Products (ProductID, ProductName, Price) and one for
Transactions (TransID *should be an AutoNumber field*, TransDate,
CustomerID, ProductID, Quantity). You can use a continuous form as a
subform to allow multiple entries directly into the Transactions table,
and display the CustomerName on the main form (link the parent/child
forms by CustomerID).

There may even be an easier way to design the form, I'm shooting this
off the top of my head after a night of heavy drinking. Certainly the
database layout I've suggested is more stable and allows for expansion.
Click to expand...
 
Back
Top