April 17, 200520 yr Have 5 Tables: People,Product,License,Catalog and Cataloglineitems To create a Catalog, info is pulled from pull downs from People and Product. One pulldown from People (for Client selection). One pulldown in portal from Product (to add product to portal) One pulldown in portal from People (to add person to portal) the rest come from Cataloglineitem table. Catalog is now created on to the License. Then in License I need to get the exact info created in Catalog + or - a couple of fields to create a license. User first chooses Customer from pulldown coming from People. All of the above working fine...no problemo! NOW...I would like the user to have a pulldown to select the Client and as that is done it shows you in a scrollable list all of this Clients Catalog items created previously in Catalog to show. The user would then select a particular item in the Catalog by using a checkbox or selecting the whole row so that info now becomes the License. I will also need a similar thing happening in product. I would prefer not to do a Lookup and recopy the info that is there already but...? What would be the most efficient way to do this? --------------------------------------------------------- I tried some of the suggested posts and couldn't get them to work in my situation. I wonder if I was clear enough in my description so I decided to send a file for clarification. One thing that came up is the ability to create printed reports for...almost anywhere, so now portal use is concerning me (inability to print all records in portal)should there be a view list instead in some areas?: Thanks 282R6.zip
Create an account or sign in to comment