Beginner Relationship Help

[ATLBryan]

I think I need to create a many-to-many relationship, but I am a little confused and not sure where to go for help. (Creating my first database, and it's turning out to be pretty complicated)

I have a list of customers (numbered 1-121) and a list of managers assigned to the customers (roughly 70 managers numbered 1001 to 1070). Many of the customers have 1, 2 or 3 managers. Also many of the managers represent more than one customer.

How can I display multiple records in the same table?

[mr_vodka]

The many to many relationship will be established with a join table that is between the Customers and Managers table.

CustID MangID

1 1001

1 1008

2 1050

2 1069

..

etc

Look for invoicing solutions on here for lots of samples.