Form construction

I am trying to construct a form whe

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.

Musicman wrote:
I am trying to construct a form whe

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.

ok. so what should I change.

"ManningFan" wrote:

Your database design is seriously flawed. You can do this fairly
easily in a properly designed database.

Musicman wrote:
I am trying to construct a form whe

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.

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.


Musicman wrote:
ok. so what should I change.

"ManningFan" wrote:

Your database design is seriously flawed. You can do this fairly
easily in a properly designed database.

Musicman wrote:
I am trying to construct a form whe

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.

thank you, that makes sense and is very helpful.

"ManningFan" wrote:

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.


Musicman wrote:
ok. so what should I change.

"ManningFan" wrote:

Your database design is seriously flawed. You can do this fairly
easily in a properly designed database.

Musicman wrote:
I am trying to construct a form whe

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.