access 2003

aim1crzy · 09-19-2006, 08:22 PM

i don't want anyone to do my homework for me, i'm just confused on something and maybe someone can just point me in the right direction.
when i'm in access and i'm trying to do a relationship between two tables, when i hit the relationship button, nothing shows up? i made sure that both tables had at least one record that matched but that didn't seem to help. i even tried using access 2000 and 2002 but nope.... just any ideas at all?

biagio · 09-20-2006, 06:58 AM

The Relationship table will be empty until you show tables on it and then indicate the type of relationship there is between the tables.

Click the Relationship button. In the blank window that appears, right click to bring up the context menu and then select Show Table. Add the tables that require a relationship.

Then match the fields up.

That should be enough to get you going without doing your homework. Good look with what you're studing!

DeborahP · 09-20-2006, 12:41 PM

Make sure you are matching up the correct fields.

In the relationship window, you need to drag from one table to another to link the fields together. Just drag and drop on the field name.

You should see a join line, if you did this correctly.

09-19-2006, 08:22 PM	#1 (permalink)
aim1crzy Registered User Join Date: Aug 2005 Location: Detroit Posts: 94 OS: xp	access 2003 i don't want anyone to do my homework for me, i'm just confused on something and maybe someone can just point me in the right direction. when i'm in access and i'm trying to do a relationship between two tables, when i hit the relationship button, nothing shows up? i made sure that both tables had at least one record that matched but that didn't seem to help. i even tried using access 2000 and 2002 but nope.... just any ideas at all?

09-20-2006, 06:58 AM	#2 (permalink)
biagio Registered User Join Date: May 2006 Location: New Haven, CT Posts: 14 OS: XP Pro	The Relationship table will be empty until you show tables on it and then indicate the type of relationship there is between the tables. Click the Relationship button. In the blank window that appears, right click to bring up the context menu and then select Show Table. Add the tables that require a relationship. Then match the fields up. That should be enough to get you going without doing your homework. Good look with what you're studing!

09-20-2006, 12:41 PM	#3 (permalink)
DeborahP Registered User Join Date: May 2002 Location: South Carolina Posts: 29 OS: 2000	Make sure you are matching up the correct fields. In the relationship window, you need to drag from one table to another to link the fields together. Just drag and drop on the field name. You should see a join line, if you did this correctly.