Originally Posted by
June7
You have designated ID fields as primary key yet you are not using them as keys. The ID field in tblShift_Base is the primary key yet you are saving Shift into related table. Need to properly designate and use primary keys.
The form does not display records because of INNER JOIN in query. Also, each TEMP_TABLE record is joining to many records from tblShiftHrs. Don't use query, just reference TEMP_TABLE as RecordSource.
Identifying the correct percentage is dependent on both number of hours and shift. Can use a DLookup() in textbox ControlSource.
I don't understand the data structure. Why have a temp table?