many to many problems

[nowheretogo]

I am building an application that requires a many to many relationship. I have three tables: Client(PKey=ClientID), Physician(PKey=PhysicianID), and ClientID_PhysicianID. In a form, how do I populate the ClientID_PhysicianID table. I admit that this may be a rookie question, but I am truley frustrated.

Thanks
Nowheretogo

 

[DougP]

I would start by making a main form, then adding two subforms to it. here is an example

http://www.barcodeone.com/winsoft/images/MKprogram.jpg

DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive