frank_spencer
New member
- Local time
- Today, 00:29
- Joined
- Jun 9, 2007
- Messages
- 6
Can some please help with the following enquiry that is causing me a lot of pain in my final year project.
I am using Microsoft Access with MSDE as the back end. When I am creating my tables, I want to be able to set my foriegn keys as a look up value to find the primary key in another table.
I can create a look up field when I use Acesss .mdb. I.e. Create table in design view, select the relevant field, go to field options, select look up tab and create the control.
However, now I am using MSDE I am not creating a .mdb database, I create an access project (.adp) and when I go to design the table, the look up tab is not available as all I can see is the general tab.
I have tried every option and spent hours trawling the net to work out how to create a field look up in an adp database but I cant seem to resolve this.
Can someone help please as my final year project rests on this - doh!
I am using Microsoft Access with MSDE as the back end. When I am creating my tables, I want to be able to set my foriegn keys as a look up value to find the primary key in another table.
I can create a look up field when I use Acesss .mdb. I.e. Create table in design view, select the relevant field, go to field options, select look up tab and create the control.
However, now I am using MSDE I am not creating a .mdb database, I create an access project (.adp) and when I go to design the table, the look up tab is not available as all I can see is the general tab.
I have tried every option and spent hours trawling the net to work out how to create a field look up in an adp database but I cant seem to resolve this.
Can someone help please as my final year project rests on this - doh!