Milothicus
Registered User.
- Local time
- Today, 09:33
- Joined
- Sep 24, 2004
- Messages
- 134
I'm working on a timesheet database including addenda (additional budgets).
each item is associated with an addendum, which is associated with a project.
on my time item input form, i'd like two combos. one for the project, and one for the addendum.
each record in my table of items is linked to an addendum, so that foreign key is what my addendum combo is bound to. the project combo is unbound.
the problem is when i open a previously entered item, both combos are blank because the addendum combo is filtered by the project, which is blank.
how do i get the project combo to display the project without binding it?
each item is associated with an addendum, which is associated with a project.
on my time item input form, i'd like two combos. one for the project, and one for the addendum.
each record in my table of items is linked to an addendum, so that foreign key is what my addendum combo is bound to. the project combo is unbound.
the problem is when i open a previously entered item, both combos are blank because the addendum combo is filtered by the project, which is blank.
how do i get the project combo to display the project without binding it?