Re: Design Of Database

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi George

I cant believe It. Thats why everytime I have been trying to select a client in the combo Box, it wont only select its specific vehicles. Also, when I look in the ComboBox for the Clients, it creates a new "Row" in the comboBox for every registration and vehicle?

I've really hit a blank with this one. How would I relate the Clients to the vehicles?

Thank You

"George" <George@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:30AE08EC-B24E-4BF9-AC7F-7BA954B608ED@xxxxxxxxxxxxxxxx
Melissa,

I got a bit confused:

1) How your clients are related to the vehicles? One client owing more than
one vehicle?

2) By entering a new job this has to be: select a client, select a vehicle
he/she owns and then enter parts, date, amount etc?

GeorgeCY

Ο χρήστης "Melissa" έγγραψε:

Hi

I need to create a database for windscreen repairs. I have one table for
"Clients" and one table for "VehicleDetails", also I have a table for
"Jobs".

In the clients table I have, "ClientID, ClientName,TelNo,CellNo"
IN the vehicledetails table i have" vehicleId, Make,MOdel, Reg,
VinNo,EngineNo"

In the JOBS table I have, ClientName,Reg,Make,Model

Now i have a form for each "Clients" and for VehicleDetails. I would like
to create the jobs Form now, and when I create a new job, i want to be able
to select the ClientName from a drop down list, and then that specific
clients vehicle information (Make,MOdel, Reg, etc) must automatically appear
in these fields on the Jobs form. I would like to avoid subforms if
possible?

Thank you

Melissa



.

Relevant Pages

  • Re: Access points on wheels
    ... which also contains several wireless clients. ... I need to configure the APs so that the clients inside the vehicle ... could this be a DHCP issue? ...
    (comp.dcom.sys.cisco)
  • Re: Access points on wheels
    ... stationary and is connected to a server over a wired LAN. ... I need to configure the APs so that the clients inside the vehicle ...
    (comp.dcom.sys.cisco)
  • RE: Design Of Database
    ... By entering a new job this has to be: select a client, select a vehicle ... In the clients table I have, "ClientID, ClientName,TelNo,CellNo" ... In the JOBS table I have, ClientName,Reg,Make,Model ... in these fields on the Jobs form. ...
    (microsoft.public.access.forms)
  • Re: Used sedan recommendation?
    ... loaner vehicle for my clients and I'm probably going to sell it shortly ... insurance company's warranty that doesn't have a pre-existing condition ... There are some great vehicles in your price range and you have a lot to ...
    (rec.autos.tech)
  • Re: Surge Progress: U.S., Iraqis team up in Rusafa, find 70 pounds of explosives
    ... The "peacekeeper" jobs should be left to the effete, PC, whackos in our ... quantity of explosives June 17. ... after seeing Coalition Forces with the Iraqi Police. ... National Police Division in a pursuit of the vehicle. ...
    (soc.retirement)