Hello All



I have been Working on a database to assist in logging errors and issues that relate to students/teachers and their beloved laptops.

What im trying to do is create links within each table to help with the criteria that is needed when filling out forms as there would be a few people using it.


What I currently have is

table:Issues
ID
Position
User
laptop serial
opened by
Issue Description

Table:Student Detail
ID
User
Laptop Serial

Table:Teacher Details
ID
User
Laptop serial


So What i need is something like this if it is possible..

IF "position" = "Student" than use "student user" for drop down list
= "Teacher" than use "teacher user" for drop down list
(position is just a value list atm)

Than

select "Student user" and "laptop serial" in the same row as user should appear automatically
select "Teacher user" and "laptop serial" in the same row as user should appear automatically



Its been along time since last I had used Access, so im relearning how to use it again. So I firstly apologise for my ignorance and my explanation of my problem.

All help and contructive critism will be great


Thanks in advance
Matt