Print Page | Close Window

Showing Data on a Form From a Related Table

Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Schapel, Steve
Forum Description: Steve Schapel's Library
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=480
Printed Date: 11 Dec 2017 at 9:35pm


Topic: Showing Data on a Form From a Related Table
Posted By: Steve Schapel
Subject: Showing Data on a Form From a Related Table
Date Posted: 04 Jul 2009 at 12:31pm
Showing Data on a Form From a Related Table
 
This is a common requirement in a database application.  Here are a few random examples:
  • You rent cars.  You have a form based on a Hires table, which uses the vehicle’s Registration Number to identify which car is being rented.  But you want the car’s description to also show on the form, and this information is in another table (Vehicles).
  • You are running a sports tournament for seeded players.  You are using a form to enter playing schedules.  But you want the seed rankings to also show on the form, and this information is in another table (Players).
  • You are a plumber.  You have a form for creating a Quote for a customer, based on the CustomerID.  But you want the customer’s address and phone number to also show on the form, and this information is in another table.

Here are four commonly used approaches to this…

Read more here:  http://accesstips.datamanagementsolutions.biz/lookup.htm - http://accesstips.datamanagementsolutions.biz/lookup.htm



-------------
Steve Schapel
http://accesstips.datamanagementsolutions.biz/ - http://accesstips.datamanagementsolutions.biz/



Print Page | Close Window