one to many relationship

1

1aae

I'm sorry for your time?
I have (1 table) contain all my data:
fk pk empname
1 1 John
2 2 v
1 3 Marshal
1 4 bill
You see in the previous example field number 1 and 3, 4 have the same fk:
I'm using FormA and FomrB
and I have command button to open Form B to display related Field to
((((((((((((current field of formA)))))))))))))))
When Form B is open the data will be
fk pk empname
1 1 John
1 3 Marshal
1 4 bill
ok until know work correct:
What I want to do:
when the cursor in one of the related field see ((((((((((((don't display me
in FormB))))))
again:
current record will not be display with field have same FK in FormB
The example
should be like this the current record is first John formB display only and
exclude john
fk pk empname
1 3 Marshal
1 4 bill
Thank you
I'm very sorry for all above information and thank you
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top