Auto Relationships?

[berg891832]

Okay, I have two tables: "Students" and "Courses".

I created a relationship between the two using the StudentID field.

Now, when I use Lookup wizard to attach the list of numbers from the Students table, it creates a relationship again.

In the relationships window, it says like "Students_table 1".

How can prevent it from creating a 2nd relationship?

Berg

 

[dk]

Don't create the relationship yourself. When you use 'lookups' Access will automatically create a link, even if one already exists.

 

[berg891832]

yes, that is one work a round, but I am helping write a shortcourse for work, and I want the employees to establish the relationships manually.

 

[SydneyGeek]

In that case, don't use the lookup wizard. You can instead insert a lookup field in datasheet view that will create the lookup functionality without creating a second relationship.
1. Select a field heading
2. Insert | Lookup Field, and follow the prompts (check the toolbar -- it may be hidden inside one of the other menus but I don't think so -- don't have Access on my desktop at work)

HTH
Denis

 

[berg891832]

Cool, that will work.

Thanks,

bill