Relation in three different tables

**kzdev** · 11-22-2010, 01:20 AM

I am new in access and I am experienced a problem in relationship between tables. I have the following tables:

Code:

electronic components
=================
 
component 
-----------
resistors
capacitors
diodes
IC

Code:

resistors
======
 
value unit watt
----- ---- -----
100 Ohm 1/6
240 Ohm 1/6
1 K Ohm 1W
5 K Ohm 2W
1 M Ohm 1W

Code:

 
capacitors
========
 
value unit volts
----- ---- -----
16 uF 50V
25 uF 60V
100 uF 50V

How can I make relationship beetween them? How can relate the table components with tables resistors and capacitors?

**RuralGuy** · 11-22-2010, 03:12 AM

You cannot *force* a relationship. Either it exists or it does not. In this case I see no useful relationship.