Hi, I'm still an amateur at using Access and have just recently been introduced to normalization.

I'm looking for some advice on how to proceed with a database I'm trying to create.
I need the database to store vehicle information (name, make, model, color, license plate), along with parking information (date, time, place, who issued the notice)

My biggest question so far, is finding an efficient way to list a vehicle with what would be an undetermined number of parking slips. and then of course being able to retrieve that information on one form.

I tried using a from for VehicleInfo with a subform for ParkingInfo but I'm not getting the relationships right, the parkinginfo form is not displaying all the information connected to the license plate when the main form shows the vehicle information..

if that makes sense, any help or advice on how to proceed (or begin) would be greatly appreciated.

Thanks

Assuming that the vehicle's license tag is the prime key for the vehicle data and a foreign key for the parking data, here's how I would approach it.

First, make a little single-line continuous form for the parking stuff.

Second, make a more complex form to show the vehicular stuff.

Now on the vehicular form put a sub-form control and drop the parking sub-form in there. If you do this with the control wizard enabled, it will ask you the linking information. You can tell it the field names in the respective tables for the license tag. If you had a pre-defined relationship between the vehicle data and the parking data, you instead would be asked "use this relationship" - and it would use the predefined link for the parent/child relationship unless you answered NO.

This is a case where you might have the relationship but you cannot necessarily enable relational integrity since I could imagine you getting a report of a parking incident but not (yet) having the vehicle in your DB. (Chicken and egg sort of thing...)

Hi, I'm still an amateur at using Access and have just recently been introduced to normalization.

I'm looking for some advice on how to proceed with a database I'm trying to create.
I need the database to store vehicle information (name, make, model, color, license plate), along with parking information (date, time, place, who issued the notice)

My biggest question so far, is finding an efficient way to list a vehicle with what would be an undetermined number of parking slips. and then of course being able to retrieve that information on one form.

I tried using a from for VehicleInfo with a subform for ParkingInfo but I'm not getting the relationships right, the parkinginfo form is not displaying all the information connected to the license plate when the main form shows the vehicle information..

if that makes sense, any help or advice on how to proceed (or begin) would be greatly appreciated.

Thanks

Here is an great reference for normalization
http://r937.com/relational.html

Get your tables under control before forms and subforms.
What does name represent in your vehicleInfo?

Have you done some basic modelling using something along these lines:

People own vehicles
People drive vehicles (but people who drive vehicles don't necessarily own them)
People park vehicles
Vehicle have make , model, color, license plate
Parking location
Parking violation