My number three choice that would work in an output form would be this: > [Employees]ID <——— [Projects]PrincipleEmployeeID > <——— [Projects]ProjectMangeEmplyeerID > <——— [Projects]SupervisorEmployeeID
Your list form would consist of two or three variables housing the employee name In the form on load event, create an array cache of ID and Names In the form on display code fill in the variables on the form My number two choice would be to model the tables as below > [Project] <--[ProjectEmployeeType]--> [Employee] You could use the same variable/cache approach in the output form with this table structure, however it is a bit more complex to pull in the data during the on load. However the table structure is a more flexible design. My number one choice is instead of an output form use a listbox, you could use a single SQL query with multiple joins to the same table to pull in the data (no cache and on display). Neil Privacy Disclaimer: This message contains confidential information and is intended only for the named addressee. If you are not the named addressee you should not disseminate, distribute or copy this email. Please delete this email from your system and notify the sender immediately by replying to this email. If you are not the intended recipient you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. The Alternative Investments division of UMB Fund Services provides a full range of services to hedge funds, funds of funds and private equity funds. Any tax advice in this communication is not intended to be used, and cannot be used, by a client or any other person or entity for the purpose of (a) avoiding penalties that may be imposed on any taxpayer or (b) promoting, marketing, or recommending to another party any matter addressed herein. ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
