Hello
I am having trouble trying to link my own tbl in Access to SQL tbls that have been imported from a server.
I am running a query using the imported SQL tbls from the server that works fine. However, when I add my own tbl and try to add fields from that tbl to the query, it returns nothing.
I thought this problem was a lack of a good relationship. The SQL tbl I need to link to has two primary keys. If I add both of those fields to my own tbl, I can select both and link them with a One-to-One, but the query returns nothing.
I then thought maybe the tbls I'm trying to link to are not updatable. How, then, would one pull the info from the query and add values into my own tbls field. I thought maybe using DLookup, but without success.
Does anyone have any suggestions? Either on using DLookup to grab records from these sql tbls on the server or adding a relationship between the sql tbls and my own tbl?
Please help. Any suggestions are most appreciated.
Thanks
Jeremy
I am having trouble trying to link my own tbl in Access to SQL tbls that have been imported from a server.
I am running a query using the imported SQL tbls from the server that works fine. However, when I add my own tbl and try to add fields from that tbl to the query, it returns nothing.
I thought this problem was a lack of a good relationship. The SQL tbl I need to link to has two primary keys. If I add both of those fields to my own tbl, I can select both and link them with a One-to-One, but the query returns nothing.
I then thought maybe the tbls I'm trying to link to are not updatable. How, then, would one pull the info from the query and add values into my own tbls field. I thought maybe using DLookup, but without success.
Does anyone have any suggestions? Either on using DLookup to grab records from these sql tbls on the server or adding a relationship between the sql tbls and my own tbl?
Please help. Any suggestions are most appreciated.
Thanks
Jeremy
