PC Review


Reply
Thread Tools Rate Thread

Combination of table information

 
 
Rudi
Guest
Posts: n/a
 
      23rd May 2006
Hi. I'm a noobie in the MS Access world and I need a little help.

I have 2 tables that look something like this:

Customer
- ID_customer (Autonumber)
- Name
- ID_respresentative

Representative
- ID_representative
- Name_representative

The relation between them is like this: a customer can have none, one
or more representatives. A representative can represent only one
customer at a time.

How can I create a table that would show all the customers (the
customers that have representatives and the ones that don't) and their
representatives information.

example:

ID_cusomer | Name | ID_representative | Name_representative

1 | Customer1 | 1 | Representative1
1 | Customer1 | 2 | Representative2
2 | Customer2 | |
3 | Customer3 | 3 | Representative3
4 | Customer4 | |

Any help would be greatly appreciated.

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula in combination with pivot table Eucalypta Microsoft Excel Worksheet Functions 0 27th Jun 2008 03:58 PM
Combination of table records theredspecial Microsoft Access 4 27th Dec 2007 02:49 PM
Combination of table information Rudi Microsoft Access 17 31st May 2006 07:17 PM
Table Combination with Sorting =?Utf-8?B?RmxldGNo?= Microsoft Excel Misc 0 18th Jan 2006 05:11 PM
Probability/combination table GKGETER Microsoft Excel Worksheet Functions 13 23rd Oct 2003 03:55 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:22 PM.