How do I...

[Jenn]

I have a table that has the following:
Name
Date
Haul
Haul Rate

There are many hauls per name per date. I want to create
a form or query that I only have to input the name and
date once and still have multiple hauls and haul rates
per that name and date.

Example of what I want...

Name: John Doe
Date: 1/4/2004

Haul Haul Rate
123 Star Lane $1.50
234 Happy Street $2.00

Any help out there? Thanks!

 

[Steve Schapel]

Jenn,

One approach to this would be to make two related tables, like this...

Table: DailyHauler
DailyHaulerID
PersonName
HaulDate

Table: Hauls
HaulID
DailyHaulerID
Haul
Haul Rate

Then you would have a form based on the DailyHauler table, and onto it
put a subform based on the Hauls table.

(By the way, as an aside, note that I have changed the field names you
used... the words 'name' and 'date' have a special meaning, thay are
called reserved words, and as such they should not be used as the name
of a field or control or database object.)