how can i link a field of atable to other one that has always the same data?

[em07189]

hi everyone!

How can i link a table field with other one that has always the same records

for example:

table1 has the fields:

equip|qty|

table 2 has always the same following fields and records:

comp| cod | qty |
x1 | x11 | x12
x2 | x21 | x22

i want to link every equip field of table1 to table2 that has always the same data?

hopes this helps to understand what i want .

[llkhoutx]

Table tbEquip
PKEquip
Equip

Table tbComp
PKComp
FKEquip
txtComp
txtCod
intQty

In the Relationships window connect tbEquip.PKEquip and tbComp.FKEquip with cascading unpdates and cascading deletes.

I doubt that you want intQty in tbEquip.

[em07189]

HI!

what are cascading updates?

[llkhoutx]

You could have looked this up yourself.

http://www.ehow.com/how_13631_unders...g-updates.html

[em07189]

HI llkhoutx!

do you have a special reason why you put the prefix's "PK" before "Equip",
also PK before Comp,FK before Equip,txt before Comp,Cod and int before Qty???

Table tbEquip
PKEquip
Equip

Table tbComp
PKComp
FKEquip
txtComp
txtCod
intQty

In the Relationships window connect tbEquip.PKEquip and tbComp.FKEquip with cascading unpdates and cascading deletes.

I doubt that you want intQty in tbEquip.

[em07189]

Hi llkhoutx!

what i wanted is to link every record from tbEquip with the every content of table 2

-for example in picture bellow it should happear 425 - 44 - 4 - 4, for both record 1 and 6 . i'ts possible to do this? i have also attachaded the file test__5.zip, with this example.

[llkhoutx]

Using prefixes on fields and variables immediately identifies what data type the field/variable is.

PK == primary key
FK == foreign key
int == integer
txt == text

Using this notation (see http://www.exceluser.com/explore/vbastds.htm, http://en.wikipedia.org/wiki/Hungarian_notation and http://en.wikipedia.org/wiki/Hungarian_notation), Long after a program is written, it is easier to read and understand.

You left the foreign key control out of table tblComp causing tblEquip and tblComp to not be related. Build that relationship in the Relationship window, after first adding field FKEquip (having a numeric data type) to table tblComp. Then your tables will tumble correctly.

Did you read what cascading updates/deletes are about? I gave you a link.

[em07189]

Yes i have read it. thanks a lot for your help.

Using prefixes on fields and variables immediately identifies what data type the field/variable is.

PK == primary key
FK == foreign key
int == integer
txt == text

Using this notation (see http://www.exceluser.com/explore/vbastds.htm, http://en.wikipedia.org/wiki/Hungarian_notation and http://en.wikipedia.org/wiki/Hungarian_notation), Long after a program is written, it is easier to read and understand.

You left the foreign key control out of table tblComp causing tblEquip and tblComp to not be related. Build that relationship in the Relationship window, after first adding field FKEquip (having a numeric data type) to table tblComp. Then your tables will tumble correctly.

Did you read what cascading updates/deletes are about? I gave you a link.