If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do i display record data in a Form
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. |
#2
|
|||
|
|||
How do i display record data in a Form
"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 wrote in message ... 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. |
#3
|
|||
|
|||
How do i display record data in a Form
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 wrote in message ... 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. |
#4
|
|||
|
|||
How do i display record data in a Form
Maria
So, how are you "picking a vendor"? From a combobox? What data is the form bound to? ?The vendor table? If so, picking a vendor could be used to display that vendor's data (e.g., phone numbers). A bit more info, please... Regards Jeff Boyce Microsoft Office/Access MVP "Maria D" wrote in message ... 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 wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|