Thread: Combo box won't display correctly
View Single Post
  #2  
Old October 22nd, 2008, 06:00 PM posted to microsoft.public.access.tablesdbdesign
Pete
external usenet poster
  
Posts: 384
Default Combo box won't display correctly
The tables in my initial post should read:-

tblBankStaff
BS_ID (1 to ∞ with tblBS_Availability)
BS_Fname
BS_Lname

tblBS_Availability
BS_ID
DateFrom
DateTo

tblCareHomes
CH_ID (1 to ∞ with tblCH_Shifts)
Name
Location

tblCH_Shifts
Shift_ID
CH_ID
BS_ID
DateFrom
DateTo