i'm a little confused, let me explain myself how i set it up.
my vendor table has 5 fields (name, contact, phone, moble, fax). I also
have a data table - within this table i have that vendor field doing a lookup
to my vendor table. i was able to bring in the vendor into my form, but what
i can't get it to do is display me, the vendor info for that record. i can
use the drop down and see the different fields, but i want to display it on
the form without having to select it again.
does that make sense?
Thank you.
"Jeff Boyce" wrote:
> "How" depends on "what". What data are you storing in the vendor table and
> in what structure?
>
> Are you saying that you use multiple fields to show different vendor phone
> numbers? If so, one approach might be to use a UNION query to return all
> the phone number X vendor combinations you have...
>
> Regards
>
> Jeff Boyce
> Microsoft Office/Access MVP
>
> "Maria D" <Maria (E-Mail Removed)> wrote in message
> news:0E0756DC-C588-46D0-8CAD-(E-Mail Removed)...
> > Hello, i need help with my form.
> >
> > I have two tables, one (data table) that is just for inputting data
> > straight to the table and in that table i do have it set for my vendor as
> > a
> > look up to the vendor table. My second table (vendor) contains cell, home
> > no., and fax no.
> >
> > my problem: In the form: I want to be able to choose my vendor, and when i
> > choose that vendor(no problem choosing vendor) , i want it to display all
> > the
> > phone numbers that are in my vendor table. how do i have it display the
> > record data?
> >
> > Thank you.
>
>
>
Similar Threads
