Order date logging

[Shari]

I have asked this question many times on this board, and gotten a few
answers, but none of them are what I am looking for...

I have a database set up where all of my customers are in one table, and I
have one main form set up for them. For each customer, I would like to be
able to enter "Date Ordered", "Date Completed", and Date Faxed". I have seen
this done at the bottom of a form, where there is a box like sturcture, and
there is one line for each year ordered, but different columns for the
categories. Everytime you hit Enter, it would add another line
automatically, making the entries endless. How do I go about setting this up?

Thank you.

 

[John W. Vinson]

I have asked this question many times on this board, and gotten a few
answers, but none of them are what I am looking for...

I have a database set up where all of my customers are in one table, and I
have one main form set up for them. For each customer, I would like to be
able to enter "Date Ordered", "Date Completed", and Date Faxed". I have seen
this done at the bottom of a form, where there is a box like sturcture, and
there is one line for each year ordered, but different columns for the
categories. Everytime you hit Enter, it would add another line
automatically, making the entries endless. How do I go about setting this up?

Thank you.

The Form is secondary. A Form is JUST A WINDOW, a tool to manage data in
tables.

Stop thinking about the form for a minute (we'll get back to it). You need
another Table, specifically to hold dates of events. The "box like structure"
you're describing is called a Subform, and it's based on this related table.

I'm not sure what your business model is - what's being ordered? You say "each
year ordered" - year of what? What information other than the three dates do
you need to record about an order? Does each customer get only one order, or
multiple orders?

 

[Shari]

The order is for an annual test that must be faxed into the water utility
company. Everything else that needs to be recorded is in the body of the
form, this is the only part that I am hung up on.

 

[John W. Vinson]

The order is for an annual test that must be faxed into the water utility
company. Everything else that needs to be recorded is in the body of the
form, this is the only part that I am hung up on.

In that case I suspect you want another Orders table with fields such as
CustomerID, DateOrdered, DateCompleted, and DateFaxed. You might need other
fields if there is information about the order which might change from year to
year.

You could create a Subform based on this table, using CustomerID as the
master/child link field, and it would let you enter each year's order on a new
row, just as you described. For printing the fax you would create a Report
based on a query selecting the current (or most recent) year's record.