Mark,
I really appreciate your help. Thank you for your time.
I have followed everything exactly, but for the last step I'm a little confused.
just make a summary field on that relationship and use the second radio button to make a Checkbox Field if there are any employees associated with that computer. You might wanna call that field. [Computer is Assigned?] – Done!
Then make a report on the computers table where the computer is not assigned. – Done!
then make a report on the computers table where the computer is not assigned. – Done!
Then edit the form for that drop-down field where you are selecting a computer and rather than using the standard record picture codes use that report that you just created which is filtered for computers that are not assigned. – This is where I'm a bit confused. Two dropdowns are automatically created and added to the Employees form.
1 – Related Computer and 2 – Computer – Model.
Neither gives me the option to choose the report 'Computer IS NOT assigned' that I created, which filters as Computer is Assigned is not equal to checked.