J
Joe
Firstly, my apologies for the lengthy post but I wanted to get as much
helpful information provided as possible.
I have had great help from this forum in the past and hope that someone
might be able to point out where my design/programming error lies. I am
using Access 2003 on a Windows XP.
I am attempting to modify the Asset Database 2003 Template downloaded from
the Microsoft site, specifically the Maintenance Subform of the Maintenance
Form.
Tbl_Maintenance in the original template contains the following fields;
MaintenanceID (AutoNumber, PK)
AssetID (Number, FK)
MaintenanceDate (Date/Time)
MaintenanceDescription (Text)
MaintenancePerformedBy (Text)
MaintenanceCost (Currency)
In order to ensure consistency of criteria for maintenance descriptions I
have created Tbl_Maintenance_Description containing the fields
MaintDescrID (AutoNumber, PK)
MaintenanceDescr (Text)
Tbl_Maintenance_Description has 2 records currently entered into the table.
I have deleted the field MaintenanceDescription from Tbl_Maintenance and
added the field MaintDescrID (Number, FK)
Tables Maintenance and Maintenance_Description have a one-many relationship
set.
In the Maintenance Subform I changed the MaintenanceDescription Field to a
Combo box (cbo_MaintenanceDescription) and changed the Control Source in the
properties to MaintDescrID. Column Count is 2 with column widths 0cm; 3cm
and bound column set at 2; List rows set at 10.
The row source has the following SQL statement…
SELECT Maintenance.*, [Maintenance Description].MaintDescrID
FROM [Maintenance Description] RIGHT JOIN Maintenance ON [Maintenance
Description].MaintDescrID = Maintenance.MaintDescrID;
On going to the datasheet view of Maintenance Subform I get the number 1
showing in the combo list in two rows. This remains the same if I make the
bound column 1.
I have been trying to work out what I am doing wrong for the past two days
but it is eluding me. Any help would be greatly appreciated.
helpful information provided as possible.
I have had great help from this forum in the past and hope that someone
might be able to point out where my design/programming error lies. I am
using Access 2003 on a Windows XP.
I am attempting to modify the Asset Database 2003 Template downloaded from
the Microsoft site, specifically the Maintenance Subform of the Maintenance
Form.
Tbl_Maintenance in the original template contains the following fields;
MaintenanceID (AutoNumber, PK)
AssetID (Number, FK)
MaintenanceDate (Date/Time)
MaintenanceDescription (Text)
MaintenancePerformedBy (Text)
MaintenanceCost (Currency)
In order to ensure consistency of criteria for maintenance descriptions I
have created Tbl_Maintenance_Description containing the fields
MaintDescrID (AutoNumber, PK)
MaintenanceDescr (Text)
Tbl_Maintenance_Description has 2 records currently entered into the table.
I have deleted the field MaintenanceDescription from Tbl_Maintenance and
added the field MaintDescrID (Number, FK)
Tables Maintenance and Maintenance_Description have a one-many relationship
set.
In the Maintenance Subform I changed the MaintenanceDescription Field to a
Combo box (cbo_MaintenanceDescription) and changed the Control Source in the
properties to MaintDescrID. Column Count is 2 with column widths 0cm; 3cm
and bound column set at 2; List rows set at 10.
The row source has the following SQL statement…
SELECT Maintenance.*, [Maintenance Description].MaintDescrID
FROM [Maintenance Description] RIGHT JOIN Maintenance ON [Maintenance
Description].MaintDescrID = Maintenance.MaintDescrID;
On going to the datasheet view of Maintenance Subform I get the number 1
showing in the combo list in two rows. This remains the same if I make the
bound column 1.
I have been trying to work out what I am doing wrong for the past two days
but it is eluding me. Any help would be greatly appreciated.