Newby needing assistance: Getting data from virious tables into a new one

[Quintin]

Good day,Your help will be greatly appreciated.I have to create forms for work. The data is for staff members being given a authority t drive specific vehicles, that can change daily.I need to create a result, where I can link for a specific vehicle (with details) from one database to a driver whose details are on another database. I then need to add other date specific details such as validity period, as well as supervisors details.How would I go about achieving this with minimal fuss.Thank youKind regardsQuintin

[ranman256]

You have tVehicles and tDrivers tables,
so make tAuthorize table to hold :
VehID, DriverID, DateStart, DateEnd,Destination,etc

A driver is assigned to a vehicle for a time span to destination.
i would have a form ,combo box of drivers,
combo for vehicles.
detail fields,
then click button to produce report or what is needed.

[ssanfu]

Welcome to the forum.......

First, a clarification.

I need to create a result, where I can link for a specific vehicle (with details) from one database to a driver whose details are on another database.

Note the red words. I think you mean "Table" instead of "database". Actually work through them, don't just look at them. It will help you a lot.

Next, I would suggest you work through the tutorials at Rogers Access Library .
Then you could watch the videos and learn about Access databases at LearnFree.org. There are many lessons here.

One point: you should design your tables using paper and pencil, whiteboard, cardbaord, etc BEFORE getting on the computer. It is easier to see and modify the tables structures/designs.

I think you will need at least 3 tables:
tblVehicles
tblDrivers
jctnDriversVehicles (this is a junction table between drivers and vheicles)

Are supervisors also drivers? You might want a table for Supervisors.

You must understand the different types of relationships between tables.

Post back if/when you have questions.


Good luck with your project........



Edit: Way more info:

Here is a link to info on Database Planning and Design --various articles, videos, tutorials.

[orange]

How would I go about achieving this with minimal fuss

Start with a simple,complete description in plain English.
I see Drivers, Authority, Supervisors, ValidityPeriod as the subjects involved. Further to ssanfu's suggestions, I recommend you tell us about a day or week in your "business" that ties these subjects together in simple English/business terms.

Good luck.