IF statements

W

Workshop

I would like to know how to automatically fill in a form with another forms
details!
I have a database that stores information on a customers lawnmowers and each
service relating to them!
I would like to know how i can use exsisting information to book a delivery
or collection of a lawnmower?

If anyone has any ideas please let me know!

Thanks
 
S

Sprinks

Hi, Workshop.

It seems to me that there is a one-to-many relationship between Lawnmower
and ServiceEvents, suggesting a main form based on the Lawnmower and a
continuous subform based on service events:

Customers
-----------------
CustomerID AutoNumber
FName
LName
Address
....

Lawnmowers
-----------------
LawnmowerID AutoNumber
CustomerID Number, Foreign Key to Customers
Make
Model
Year
....etc.

ServiceEvents
------------------
ServiceEventID AutoNumber
Lawnmower Number, Foreign Key to Lawnmowers
ServiceType Number, Foreign Key to ServiceTypes
SchDate
....
etc.

With this arrangement, you wouldn't need to *copy* anything, simply add a
new ServiceEvent.

Hope that helps.
Sprinks
 
Top