Many-to-Many relationship issue

[DanKay1]

I have Billing Table and CashFlow Table
Each billingID might have several CashFlowID and each CashflowID might be assigned to several BillingIDs.

I need to create many-to-many relationship.
Do I need to create intermediate table or its possible to create this relationship with 2 tables?

 

[PHV]

A many-to-many relationship is implemented with a third table having as primary key a composite index on the 2 foreign keys.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[DanKay1]

Is there a way to define foreign key in Access?
I only see the option to create a primary key.

 

[PHV]

Yes, in the RelationShips window.
In the table design view you create an index allowing duplicates on each foreign key, then in the database window, menu Tools -> Relations ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[DanKay1]

I did it but it doesnt say foreign key anywhere. Is it just conceptual or it should state foreign key next to those fields in the intermediate table?

 

[PHV]

It is just to help the wizards help you.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244