Is This Possible

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

Guest

Hi all,

Is it possible to find a record that's split between two tables?

I want to find employees that are selected from a Combo Box using
"Employees_ID" as criterior and make that record the current record.

The two tables are "EmployeeCourseJoin" and "Main".

Can this be coded using VB?

-Simon
 
Simon

A straight-forward way to find data in two tables is to use a query, select
both tables, and join them on a common (shared) field.

Jeff Boyce
<Access MVP>
 
Jeff,

Brilliant idea. I was thinking along the lines of Dlookup or whatever and
forgot about a query.

Thanks Jeff

-Simon
 
Back
Top