Multiple copies of record

  • Thread starter Thread starter Lauri
  • Start date Start date
L

Lauri

I'm working with Access 2000
I have a bus request system, where teachers request a bus for a field trip.
Some trips require more than one bus. To save the teachers from filling out
the same information for each bus needed, I'd like to add a way for the
teachers to enter how many busses are needed and a record would be created
for each bus.

I'm thinking a button on the form if they need multiple busses, but other
suggestions are welcome.

My stumbling block is:
I have a form that is filled out. How do I copy all that information to
multiple records.

tia
-Lauri
Microsoft Office Specialist
Bellingham School District
 
Lauri,

Have you used macros in Access before? I had a similar situation where I
needed to create a SUPPLEMENTAL form based on an original work order, but
the staff didn't want to re-type all the information from the work order.

I created a button (labeled Supplemental and attached a macro to it that:
- Selected the current record
- Copied the current record
- Performed the 'Paste Append' function to create a new record at the end
of the table with all of the original information it
- Used to GO TO function to jump to the newly created record (that already
had all the copied information in it)

(I don't remember if those are all the steps in the macro, but if you think
that might work for you, I could go back and note them all from the actual
file.)

Perhaps this might be the skeleton outline of a routine you could use.
 
The best solution is to modify the structure and add a new table. The
transportation request should indicate the number of passengers but the
actual bus assignment should be in a separate table since there is a 1-many
relationship between trips and buses.
Storing duplicate data will simply make any statistical reporting
impossible.
 
I'd go a bit further than Pat's comment, as if the school own the bus, then
it may be used on more than 1 trip. You therefore have a many to many
relationship, requiring 3 tables.
 
Back
Top