Hi there,
I'm a newbie in Access. I would like to use Access 2007 to connect to a
sql
server 2005 database to view and update data in the sql tables. I'm
currently using OBDC to link my "*.accdb" project to the Sql Server 2005
database. The problem is that I have (of course) foreign keys (and
therefore
relations) in the sql database and that I can't see these relations in
Access.
My goal at first was to have a "nice" way to fill in the foreign data (I
imagine a sort of listbox filled in with all the primary keys available in
the database). Perhaps I'm wrong and Access can't do that for me.
Anyway, I wonder if the "adp" project is the solution or if there is
another
way to proceed ?
Oriane
