how to link two field without primary key???

M

miles

hi,

i got another problem.................................

how to link two field together without primary key.

i have link them through the relationships but when i key in in either
one of them nothing react on the other ..................

what should i do????

eg ISSUED_issued INVENTORY_issued
(key in) 1 0

cannot link together ....

pls help

thanks
 
R

Rick Brandt

miles said:
hi,

i got another problem.................................

how to link two field together without primary key.

i have link them through the relationships but when i key in in either
one of them nothing react on the other ..................

what should i do????

eg ISSUED_issued INVENTORY_issued
(key in) 1 0
Click to expand...

What are you expecting the "link" to do? Table relationships do not cause new
data entered in one table to automatically show up in another.
 
E

Ernest Lai

Lets say you have two tables. In both tables have the same field say Invoice
number.

You can create a query and link the two tables with this Invoice field.

Just drag the invoice field from one table to the other. A line will be
drawn between the two, indicating a link.

Now when you draw information from one table it can look up information in
the other.
 
Top