Hi.
Vista Ultimate
Access 2007

I'm developing an inventory database and have question on design. The database stores collection details. One item in the collection, one record. The design question is about showing related items. For example:
I have a typewriter Model 1
I have a manual for typewriter Model 1
I have a manual for typewriter Model 2 but no typewriter model 2.

What I...

Hi.

VB 2008 Express
Vista Home

I have an .mdb backend. In that database are two tables tblVechicleDeta ils and lkpManufacturer s. tblVehicleDetai ls has an integer field ManuacturerKey and likewise does lkpManufacturer s. lkpManufacturer s also has a field with the Manufacturers real world name. What I'd like is for the field manufacturers from its table showing on a form filled with details from tblVehicleDetai ls....