omniaccess
Technical User
If you are familiar with Outlook, you know it has categories on the appointment screen that you can select from a checklist. The example of what I want to recreate is the category selection for an appointment the same as Outlook.
I can make the continuous-form subform look the same as Outlook, and if I open the form without making it a subform, each line shows properly (a checkbox with a category, all available categories showing). But, when I connect the subform to the main form,
For tables look like this:
tblScheduleAllocatedTable (This table is empty)
(This table keeps what categories are allocated to which schedule item)
AllocatedCategoryID AutoNumber
CategorySelect Yes/No
CategoryIDLink Long Integer
ScheduleIDLink Long Integer
tblCategoryTable (This contains Category List)
CategoryID AutoNumber
CategoryName Text, 20
CategoryDescription Text, 80
Whese two tables are linked as Showing all of 'tblCategoryTable' and showing matching 'tblScheduleAllocatedTable' and I view JUST the subform, everything is fine.
But, when this subform is linked to a schedule item, nothing shows up. It is linked from ScheduleIDLink (Child) to ScheduleID (Parent). I can understand why, because there is no reference in 'tblScheduleAllocatedTable' yet for the schedule item, because no category has yet been selected, and there is no record in 'tblScheduleAllocatedTable'.
I need to find out:
1) Am I doing the connection of the tables wrong?
2) What layout of tables is necessary?
3) Is there some coding to make the whole list show?
4) How to have the same subform show all existing categories and a check next to those previously chosen whenever the categories are viewed again?
5) How to get those categories to then show up on the parent form as 'Business, Personal, Accounting' (again, my reference to Outlook)?
I hope this gives information to help my situation. If I have not given enough info, please look at the layout in Outlook for appointment categories, because it shows exactly what I am trying to recreate in Access.
Thomas
I can make the continuous-form subform look the same as Outlook, and if I open the form without making it a subform, each line shows properly (a checkbox with a category, all available categories showing). But, when I connect the subform to the main form,
For tables look like this:
tblScheduleAllocatedTable (This table is empty)
(This table keeps what categories are allocated to which schedule item)
AllocatedCategoryID AutoNumber
CategorySelect Yes/No
CategoryIDLink Long Integer
ScheduleIDLink Long Integer
tblCategoryTable (This contains Category List)
CategoryID AutoNumber
CategoryName Text, 20
CategoryDescription Text, 80
Whese two tables are linked as Showing all of 'tblCategoryTable' and showing matching 'tblScheduleAllocatedTable' and I view JUST the subform, everything is fine.
But, when this subform is linked to a schedule item, nothing shows up. It is linked from ScheduleIDLink (Child) to ScheduleID (Parent). I can understand why, because there is no reference in 'tblScheduleAllocatedTable' yet for the schedule item, because no category has yet been selected, and there is no record in 'tblScheduleAllocatedTable'.
I need to find out:
1) Am I doing the connection of the tables wrong?
2) What layout of tables is necessary?
3) Is there some coding to make the whole list show?
4) How to have the same subform show all existing categories and a check next to those previously chosen whenever the categories are viewed again?
5) How to get those categories to then show up on the parent form as 'Business, Personal, Accounting' (again, my reference to Outlook)?
I hope this gives information to help my situation. If I have not given enough info, please look at the layout in Outlook for appointment categories, because it shows exactly what I am trying to recreate in Access.
Thomas
