Matching Unique Fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two tables, both have a unique field (AFS). How do I code a textbox
that shows only those AFS's that match in both tables?
 
I have two tables, both have a unique field (AFS). How do I code a textbox
that shows only those AFS's that match in both tables?
Click to expand...

A *textbox*? What if there were 33812 records which matched? What do
you want to see on the screen? It would need to be a rather large
textbox!

You can create a Query joining the two tables by AFS, and select
whatever fields you would like to see from this Query; you can then
base a Form (for onscreen viewing) or Report (for printing) on the
query.

John W. Vinson[MVP]
 
Back
Top