Go Back   Access World Forums > Microsoft Access Discussion > Tables

Thread Tools Rating: Thread Rating: 2 votes, 5.00 average. Display Modes
Old 11-25-2002, 10:52 AM   #1
Posts: n/a
Update table with data from another table via form

This seemed like a remarkably simple problem at first but.........have recently become confused. I have a basic automotive service DB with multiple tables. The main table is the vehicles table with co. vehicles, drivers and other vehicle info (PK is the Vehicle #.) I also have a service table with typical services - lube, oil, and filter, transmission service, brake job, and other misc. goodies (PK = Service ID SK=Vehicle#.) The third table consists of prices for each service (PK=Service Price ID SK= Service ID.) I'm trying to create some way of having the user click on a service and have the service and price be entered into a subform on the vehicle subform. Any solutions?

  Reply With Quote
Old 12-02-2002, 10:10 AM   #2
Posts: n/a
Solution Found

For anyone looking for a solution to this or similar problems I have found a thread which will help. Do a search for "Auto Fill based on Combo Box" without the quotes. This is a found in the Forms section and will either solve the problem or lead to a solution.
  Reply With Quote

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

All times are GMT -8. The time now is 03:06 PM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World