GShen - You are so kind!!!
I do understand joins. I will make my attempt today and will let you know how it comes out. I can't thank you enough for being so responsive. Talk to you soon!!!
CTQ
Yes, I am using tables.
(1) Table one has the vendor info
(2) Table two has the products and the vendor assigned to it
(3) Table three is the order table which is blank until I make my first order.
I want to go to my form and choose the vendor and the vendor pops up or fill in, then I want to...
This is an MDB file. I am using Microsoft Access. I don't know much bout SQL so do my best to stay out of that area at this time. I use the forms wizard to make all forms and from time to time, take a look out back, so to speak, to view the programming.
The radio buttons seem pretty easy, my...
GShen - thanks for your reply - I will try to explain it better.
I have a product, vendor and order table. I want to set up a form that will allow me to choose my product and the product info fills in with the product info including the vendor name, address, contact person. Then I want to be...
I am somewhat new to Access. I am trying to set up a form which will allow me to choose my vendor and the info about that vendor comes up. I feel sure i need to rethink my tables to make sure the relationships are right, but it gets confusing. Here goes:
I have a table with vendors and...
I am somewhat new to Access. I am trying to set up a form which will allow me to choose my vendor and the info about that vendor comes up. I feel sure i need to rethink my tables to make sure the relationships are right, but it gets confusing. Here goes:
I have a table with vendors and...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.