Search results

  1. B

    Foreign Keys in Access 2007

    I've attached my database in a zip file. I think it's in 2003 format though (as I had to take it home) I've been trying to get everything set up correctly so that I can create one big form (to give to the customer) which allows the user to select modules and software from their respective...
  2. B

    Foreign Keys in Access 2007

    I've done everything that you said. However, I'm certain that in Access 2003 you could specify with a button that a field was a foreign key. Also, in the relationships screen it would be emboldened when there was a foreign key. Basically I'm having trouble getting the form for CustMod to...
  3. B

    Foreign Keys in Access 2007

    Thanks for your reply, Yes I did make these tables and I have referential integrity. However, it doesn't seem to be visually showing that it's a foreign key. I know that in 2003 I was able to add foreign keys. Ultimately though the reason I want to do this is because I'm trying to make a form...
  4. B

    Foreign Keys in Access 2007

    Hi, I have to create a database for work and for my sins I have to use Access. We are running 2007 but I'm having some difficulty in creating foreign keys in my linking table. I've searched their help guide and looked on the net but I can't seem to see how I physically create foreign keys. My...
Back
Top Bottom