G
Guest
hi,
the problem is, i have a bunch of mandates, and each mandate has lots of
different checks. in order to make the database easier to use, i want to
make a lookup combo box which allow users to search for the required
mandates. As a mandate has lots of checks, i also like to have lookup combo
box which allows the users to search for the checks of the selected mandate.
So in a form, after the user have searched a mandate, the form will show the
information of the mandate and one of the checks; afterwards the user search
for the check of that mandate and the lookup combo box will only show the
checks of that mandate, the form should show the information of the check as
related to the mandate.
i have already created a query to link the mandate and the checks to create
a single form.
how should i arrange the form and what coding do i need? thanks!!
Best regards,
Hackman
the problem is, i have a bunch of mandates, and each mandate has lots of
different checks. in order to make the database easier to use, i want to
make a lookup combo box which allow users to search for the required
mandates. As a mandate has lots of checks, i also like to have lookup combo
box which allows the users to search for the checks of the selected mandate.
So in a form, after the user have searched a mandate, the form will show the
information of the mandate and one of the checks; afterwards the user search
for the check of that mandate and the lookup combo box will only show the
checks of that mandate, the form should show the information of the check as
related to the mandate.
i have already created a query to link the mandate and the checks to create
a single form.
how should i arrange the form and what coding do i need? thanks!!
Best regards,
Hackman