I'm making a DB to schedule the maintenance of buildings.
It has three tables with a many to many relation where the primary key for the middle table is a compound primary key with two foreign keys.
"Building"->ID Number (PK), Name, Construction Date, Address; City, Postal Code.
"Building Components List"->Building ID (FK), Components List (FK), Last Maintenance Date.
"Components List"->List ID (PK), Part, Subpart, Specific part.
And a fourth table for the maintenance where it made a compound foreign key to the "Building Components List".
"Maintenance"->Maintenance ID (PK), (Building ID, List ID) (FK), Status, Cost, Start Date, End Date, Observations.
On the Maintenance form I want to choose the building and a component from that specific building to schedule the maintenance, so I decide to use cascade List Box with the filter-table for aid as I read on this forum posted by DACM, Villeroy and RPG.
But I really cant understand what I'm doing wrong, because I can choose the building but the second listbox doesn't read the parts from that building specific, and It doesn't record a value to the "List ID" column on the "Maintenance" table.
I've search on this forum for something like this, but the examples are not with the same linking (some are not linked at all).
I don't know if is my structure that is wrong or just the filters on the form "Filter Building Components exp form".
Can anyone have a look at this.
Many thanks!
			
							Many-to-many relationship cascade list box
Many-to-many relationship cascade list box
- Attachments
 - 
			
		
		
				
- Maintenance_db.odb
 - Maintenance file DB.
 - (51.33 KiB) Downloaded 291 times
 
 
OpenOffice 3.4.1 /Windows XP