lookup info in 1 table gives info out of second, but how vice versa ?

[lesaint]

Hello and tx in advance for the help :

I have a form with adres and more.
When i select a record, on a subform i receive the contact person for that specifique record.

But now I want to do it the other way too :
When i'm in my subform "contacts" I want to look up a certain contact, select it, and my "address form" should give me the corresponding record.


How do I do that ????

Help please

 

[Pat Hartman]

Make a second set of forms with the contact being the main form and the other data being the subform.

 

[lesaint]

Tx ok I understand that, but that is halve of the solution :

I'm working with a "address" main form in witch, as you exactly say, is a subform "contacts" linked to the main form.
I swith from one to another using "Tab control" from the toolbox.

I understand that I can do the oposite too, but ...

But how do I make a "screen" or form or whatever, that can integrate both "main forms" on the same time ?

My goal is to seek information on as less different screens as possible, with as less as possible mouseclicks.


Thank you allready for the response

greetings

 

[Pat Hartman]

You have a many-to-many relationship. Surely when a user comes to the db for information he will come with information from one side of the relationship or the other and moreover, he will know what info he has. Take a look at the sample man-to-many db I posted a while ago and see if that helps you.

 

[lesaint]

ok thanks a lot, I saw your example.

I had allready such kind of solutions.

But in concreto, the way I want it to be, isn't possible, as I asume.


Many tx for your time and help
greetings