IF statements

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

New database 7
Them delivery services - some good, some not so good 3
Collect and update via email with a Table/spreadsheet 1
Automatically adding a record 1
trying to set up a database for billing customers and tracking ser 2
Not recorded unless tab opened 2
receiving error "id" is not an index in this table error 3800. 1
Optional Address in Form 7

Back
Top