a relation ship connecting field to table head?!? What kind of rs isit?

[Yabi]

Today I checked an access file written by Microsoft as a template. In
query design, I see a relation ship connecting a field to the head of
another table. Until now I thought the relationship could be defined
only between fields.
What kind of relationship is it and what is called if I want to search
for more info on it?

The add for the template I download:
http://office.microsoft.com/templat...2186931033&Application=AC&Result=2&Version=11

 

[Allen Browne]

I'm not seeing that.

The Issue Tracker database has a one-to-many relation:
Contacts.ID => Issues.[Assigned To]

Perhaps you need to scroll up the Contacts table or increase its height so
you can see the ID field.

 

[banem2]

I'm not seeing that.

The Issue Tracker database has a one-to-many relation:
    Contacts.ID => Issues.[Assigned To]

Perhaps you need to scroll up the Contacts table or increase its height so
you can see the ID field.

--
Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

Today I checked an access file written by Microsoft as a template. In
query design, I see a relation ship connecting a field to the head of
another table. Until now I thought the relationship could be defined
only between fields.
What kind of relationship is it and what is called if I want to search
for more info on it?

The add for the template I download:
http://office.microsoft.com/templates/directdownload.aspx?AssetID=TC0....

Also on some older graphic cards and while using Windows XP theme,
query design can be a confusing for several seconds. I've seen it just
a couple of times. When I open any query in design view I could not
resize tables (need to wait around 10 seconds). So the issue might be
related to graphic card driver.

Regards,
Branislav Mihaljev
Microsoft Access MVP

 

[Yabi]

I'm not seeing that.

The Issue Tracker database has a one-to-many relation:
    Contacts.ID => Issues.[Assigned To]

Perhaps you need to scroll up the Contacts table or increase its height so
you can see the ID field.

--
Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

Today I checked an access file written by Microsoft as a template. In
query design, I see a relation ship connecting a field to the head of
another table. Until now I thought the relationship could be defined
only between fields.
What kind of relationship is it and what is called if I want to search
for more info on it?

The add for the template I download:
http://office.microsoft.com/templates/directdownload.aspx?AssetID=TC0....

Thanks for your input
Did you open the link I mentioned?
I don't the file with myself to check now, but I do remember that in
query three tables are related to each other. One goes from the
central table to the head of both other tables (by head I mean where
the name of table appears, just above all field names).