I’m planning to do some customization in the FindPrinter function as I’ve a multiple company database where each user need need to print the same report to different printers. The Primary Key for the Printer Selection Table (78) is “User ID” , “Report ID” So I thought of changing the key to “User ID” , “Report ID”, “Company Name” Then customize the FindPrinter function accordingly to retrieve the correct printer name based on UserID, CompanyName and Report ID. This seems nice and easy but I was wondering if someone has done something similar and has ended up with some problems, but if it’s safe to do so please let me know too [;)] I do not like the idea of chaning the PK on this table but I do not see any other alternatives. [This is for a 3.60 Native DB]
Hi Tarek, I have changed the PK of the Printer Selection table. (I had to include a printer type: normal, fax, email. For automated sending) and I also made mods to the FindPrinter Funciton in CU1 I have not experienced any adverse affects yet… everything has been working perfectly for about 2 months.
Hi Steven, Awesome! Thanks for your inputs!
Did the same thing. If you export all objects to a txt file and do a search for the key you will see the table is only used in 2 objects.
What about to change DataPerCompany to No on table “Printer Selection”??? It must be sufficient…
quote:
What about to change DataPerCompany to No on table “Printer Selection”??? It must be sufficient…
Originally posted by Kine - 2005 Mar 25 : 08:33:26
That reply made me you you a 5-star rating