Real quick question, can anyone point me to an article discussing how
to use a listbox where the data comes from a lookup table to store
multiple records in a child table? I created a form based on a select
query that joins the parent and child records, but it's not an obvious
solution. I'm sure it's easy though, any links?
On Fri, 25 Jan 2008 14:00:01 -0800 (PST), bbcrock@gmail.com wrote:
I'm not quite following your scenario, but suffice to say a
multiselect listbox cannot be bound. You will have to select items in
code.
For a one-to-many solution the more typical implementation is a
form/subform.
-Tom.
>Real quick question, can anyone point me to an article discussing how
>to use a listbox where the data comes from a lookup table to store
>multiple records in a child table? I created a form based on a select
>query that joins the parent and child records, but it's not an obvious
>solution. I'm sure it's easy though, any links?
Oh. I have one subform already, so the idea would be to put this
subform inside another subform?
On Jan 25, 10:29 pm, Tom van Stiphout
> On Fri, 25 Jan 2008 14:00:01 -0800 (PST), bbcr...@gmail.com wrote:
>
> I'm not quite following your scenario, but suffice to say a
> multiselect listbox cannot be bound. You will have to select items in
> code.
> For a one-to-many solution the more typical implementation is a
> form/subform.
>
> -Tom.
>
> >Real quick question, can anyone point me to an article discussing how
> >to use a listbox where the data comes from a lookup table to store
> >multiple records in a child table? I created a form based on a select
> >query that joins the parent and child records, but it's not an obvious
> >solution. I'm sure it's easy though, any links?
On Mon, 28 Jan 2008 04:48:49 -0800 (PST), bbcrock@gmail.com wrote:
You can, but that creates a UI most suitable for experienced users.
The alternative is to have two subforms, with the second one showing
the subrecords of the first one.
-Tom.
>Oh. I have one subform already, so the idea would be to put this
>subform inside another subform?
>
>
>On Jan 25, 10:29 pm, Tom van Stiphout
>> On Fri, 25 Jan 2008 14:00:01 -0800 (PST), bbcr...@gmail.com wrote:
>>
>> I'm not quite following your scenario, but suffice to say a
>> multiselect listbox cannot be bound. You will have to select items in
>> code.
>> For a one-to-many solution the more typical implementation is a
>> form/subform.
>>
>> -Tom.
>>
>> >Real quick question, can anyone point me to an article discussing how
>> >to use a listbox where the data comes from a lookup table to store
>> >multiple records in a child table? I created a form based on a select
>> >query that joins the parent and child records, but it's not an obvious
>> >solution. I'm sure it's easy though, any links?