Fred
2011-05-17 02:24:05 UTC
I am using Access 2007. I need to create a form that is based on data
contained in the following tables:Furniture, Furniture Category, and
Furniture_and_Categories
Furniture
-----------------------------------------
Furniture ID
Furniture Name
Furniture Types
-----------------------------------------
Furniture Type ID
Furniture Type Name
Furniture_and_Types
-----------------------------------------
Furniture ID (from Furniture table)
Furniture Type ID (from Furniture Types table)
I need to create a form that displays as text only, the name of a
vehicle and below that a list of all the vehicle types that can be
associated with the current vehicle. I then need to be able to add or
remove vehicle types (from the Vehicle_and_Types table) to the current
vehicle.
What is the best way to do this? I can create a sub form using the
wizard, but cannot get it to allow for entry using a drop-down to add
new records.
Any guidance would be tremendously appreciated.
contained in the following tables:Furniture, Furniture Category, and
Furniture_and_Categories
Furniture
-----------------------------------------
Furniture ID
Furniture Name
Furniture Types
-----------------------------------------
Furniture Type ID
Furniture Type Name
Furniture_and_Types
-----------------------------------------
Furniture ID (from Furniture table)
Furniture Type ID (from Furniture Types table)
I need to create a form that displays as text only, the name of a
vehicle and below that a list of all the vehicle types that can be
associated with the current vehicle. I then need to be able to add or
remove vehicle types (from the Vehicle_and_Types table) to the current
vehicle.
What is the best way to do this? I can create a sub form using the
wizard, but cannot get it to allow for entry using a drop-down to add
new records.
Any guidance would be tremendously appreciated.