A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Table Linking??



 
 
Thread Tools Display Modes
  #1  
Old January 26th, 2005, 12:07 AM
Ryis
external usenet poster
 
Posts: n/a
Default Table Linking??

Hello,
What I would like to do is link one table to another but have the second
table use a fields alpha/numeric info and add some alpha/numeric info to it.
then I would like to have a third table use that new alpha/numeric entry and
add to it some more to keep everything linked in the back ground for quering.
Can this be done?

thanks in advance

ryan
  #2  
Old January 26th, 2005, 08:46 AM
John Nurick
external usenet poster
 
Posts: n/a
Default

Hi Ryan,

It can be done, but probably shouldn't. If you tell us a bit more about
the real-world situation you need to model, someone will be able to make
some suggestions for a suitable structure.


On Tue, 25 Jan 2005 15:07:01 -0800, "Ryis"
wrote:

Hello,
What I would like to do is link one table to another but have the second
table use a fields alpha/numeric info and add some alpha/numeric info to it.
then I would like to have a third table use that new alpha/numeric entry and
add to it some more to keep everything linked in the back ground for quering.
Can this be done?

thanks in advance

ryan


--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Get data from combo box to popluate the next box Lin Light Using Forms 4 December 30th, 2004 06:01 PM
Update - If statement Dan @BCBS Running & Setting Up Queries 13 December 14th, 2004 07:02 PM
Semicolon delimited text query help Al Guerra Running & Setting Up Queries 3 August 12th, 2004 11:50 AM
combining tables and linking records with queries Dale Peart Running & Setting Up Queries 2 July 9th, 2004 11:36 PM
Access 2002: Linking table indices George Fowler Database Design 2 June 11th, 2004 12:34 AM


All times are GMT +1. The time now is 10:56 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.