trouble linking table fields

[stillabeginr]

Hello,

I created a sys admin database and the big problem I am having is linking the hostname field in table 1 to the hostname field in table 2. I have tried making both fields primary keys, I have tried creating a relationship to the two fields between the two tables. I have tried adjusting the join types.

Yet, no matter what I try, the hostnames from table 1 will not populate in table 2. I have even tried adding a new hostname to see if it would populate and it won't.

any ideas?

Thanks,

stillabeginr

 

[quest4]

Two PKeys will not link together. In table2 try adding Talble2Id and make it the PKey, now change HostName in table2 to long integer. Now in relationships link the Hostname of Table1 to HostName of Table 2 and now you should be able to turn on referential integerty and cascade updates and delete. hth.