Table Reference Difficulties

[unclefink]

Please forgive me if this is already mentioned in another post as i'm new to this forum.

I have a table which tracks employees with various information about the employee, one of which is a "yes/no" field referencing "former employee".

On a Separate table, I am trying to track License numbers, this specific table will only have three columns, "Employee Name", "License Number", and "License Expiration Date".

I have been able to reference the "License" table to the "employee" table; however I only want the Current employees on the employee table to show up in the list of possible employees rather than the entire list when I add a License.

Any help would be appreciated.

David

 

[cookiegary01]

Hi David,
If your " reference" is done correctly, then Create a query containing all the fields of these two tables that you need to see in the output.
In the criteria row of your yes/no field, fill in either TRUE or FALSE, depending on what you need to see.
I advise you to check the video tutorials, it will teach you a great deal.

 

[unclefink]

Cookie,

I think I have already done some of this. Here is what I've done so far.

The first table titled "Employees" has been made which contains Employee names, information about each employee and whether the person is a curent or former employee indicated by a "check box" in a "former employee" column.

The second table, is the License table which tracks the Employees name, which i'm obviously referencing from the employee table. In this table, i've got the Employee Name set as a lookup on the Employee table, however that is listing all employees.

I've created a query on the Employee table and told it to only tell me the "Current employees" and attempted to reference the combination box, however when i test it with data, it tells me the properties are different data options.

You referenced a tutorial video, can you let me know where I can find that video?

respectfully,

David

 

[cookiegary01]

Hi,
Video Tutorials = on the Top right side under "Microsoft Access help".
General, Tables, Queries, Forms etc.
Good luck

 

[unclefink]

Cookie,

I seemed to have picked up on some key notes you left which pointed me to a different direction. I followed up on that and it seems to be working now. Thanks for responding. I appreciate the help.

David

 

[unclefink]

Back to the drawing board. So I thought I figured it out, until I tried to start data and cross referencing the primary data from the employee table. No Go. Anymore suggestions, anyone????

 

[cookiegary01]

David,
It's not easy to understand what you are saying.
Can you post your database here, so that someone can check it out for you?