Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Populate a textbox if a value exists in a related field
The database is for a business that designs and builds kitchens and bathrooms. Each order is a project for which items and components are individually ordered every time as each project is unique. Therefore everything for a project is ordered specifically for each project when it is...- rockieme
- Post #10
- Forum: Microsoft: Access Forms
-
Populate a textbox if a value exists in a related field
You have grasped the scenario very well. The Product purchases table is for products that we purchase at wholesale price. Product markups table shows the markups to arrive at the price we sell at. Product listing table lists the products available that we can purchase and the price of those...- rockieme
- Post #7
- Forum: Microsoft: Access Forms
-
Populate a textbox if a value exists in a related field
Thanks for helping out. I actually have three linked tables in a query. One table is for actual Product Purchases. Another table is for Product Markups (markups for resale)This basically serves as a junction table connecting the two other tables. The third table lists all the products and the...- rockieme
- Post #5
- Forum: Microsoft: Access Forms
-
Populate a textbox if a value exists in a related field
I have a text box in an Access form for entering the cost of products purchased. The form's source is a query that draws its information from two tables. One of the tables lists the products with a cost for some of them (those that will seldom change). The prices of the other products will...- rockieme
- Thread
- Replies: 9
- Forum: Microsoft: Access Forms
