ComputerForum.com ComputerForum.com  
TigerDirect
 
Go Back   Computer Forum > Computer Software > General Software

Reply
 
LinkBack Thread Tools Display Modes
Old 03-12-2008, 11:26 AM   #1 (permalink)
Platinum Member
 
Jon Boy's Avatar
 
Join Date: Feb 2005
Location: England
Age: 20
Posts: 704
Default MS Access help please

Hello I have a little problem in access when setting relationships. I have always been told to enforce referential integrity or everything goes wrong .

So anyway I have 2 tables and need two of one value to be in the table twice. if you get what I mean. To explain
Quote:
Originally Posted by Me
_ = PK
* = FK
Table Antenna
ID
Description

Table Access Point
Details etc etc ......
Antenna1 *
Antenna 2 *
As you can see each AP has 2 Antenna but I cannot set up two relationships without enforcing referential integrity.

Can someone please help on this subject please?

Thanks

Jon
__________________
Intel Core 2 Quad Pro Q6600 95W G0 Stepping
Western Digital Caviar 320GB S300 16MB
OCZ 4GB DDR2 800MHz DUAL CHANNEL
GeForce 8800GTS 320MB "XT" ED
OCZ GameXStream 700W PSU
ASUS P5K-E/WIFI-AP
"3D Mark 03 - 31164" -- "3D Mark 05 - 14127" -- "3D Mark 06 - 10393"
Jon Boy is offline   Reply With Quote


Old 03-12-2008, 11:28 AM   #2 (permalink)
Platinum Member
 
Jon Boy's Avatar
 
Join Date: Feb 2005
Location: England
Age: 20
Posts: 704
Default

I have been thinking would I need a new table?

For example set up Antenna config this causes a lot of repeated data though I guess.

Its anoying cos many APs have many Antenna but you can't have many to many
__________________
Intel Core 2 Quad Pro Q6600 95W G0 Stepping
Western Digital Caviar 320GB S300 16MB
OCZ 4GB DDR2 800MHz DUAL CHANNEL
GeForce 8800GTS 320MB "XT" ED
OCZ GameXStream 700W PSU
ASUS P5K-E/WIFI-AP
"3D Mark 03 - 31164" -- "3D Mark 05 - 14127" -- "3D Mark 06 - 10393"
Jon Boy is offline   Reply With Quote
Reply

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
cant access laptop jake87 Computer Networking and Servers 12 05-09-2006 10:18 AM
Configuring an Access Point markherman5 Computer Networking and Servers 0 11-19-2005 01:14 AM
Hijack This Log -- Help please Jameseee Computer Security 20 07-19-2005 08:44 PM
Can't access random sites steview Internet Discussion 5 05-20-2005 02:34 AM
Linking Access and Excel Ryad General Software 1 12-06-2004 03:47 PM


All times are GMT +1. The time now is 12:52 PM.


Powered by: vBulletin Version 3.7.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.1.0 ©2007, Crawlability, Inc.
Copyright © 2002-2007 Computer Forum and Web Design Forum