Forum Discussion
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.
If you edit the form properties for the drop down field to select related computer, there will be an option in he choices below "use record picker" to select a report to use.
------------------------------
Mark Shnier (Your Quickbase Coach)
[email protected]
------------------------------
- StuLamden12 years agoQrew Member
Mark,
Thank you for your help! This accomplished exactly what I needed.
Stu