slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Architect Forums - SalesLogix Scripting & Customization
Forum to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to SalesLogix Scripting & Customization | New Thread

View: Search:

Author

Thread: Adding child records to ticket add form?

Aaron Lowe
Posts: 37

Adding child records to ticket add form? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 13 Jul 09 12:14 PM

We have a form in the ticket system where our tech support guy can attach VINs or serial numbers to trouble tickets. This works fine and they can add multiple VINs to a ticket. The problem is that they want to add the VINs while they are on the phone with the dealer and want to do all this in the "Add Ticket" form.

I tried adding a datagrid to that form, but since the ticket isn't actually in the database until they click "OK" and get out of that form, the datagrid has no TICKETID to connect to and the data for the VINs is never saved.

So is there a way to be able to attach multiple child records to a ticket in the "Add Ticket" form? Can we still use a datagrid? If so, how do you insert the TICKETID when the ticket doesn't exist yet?

We thought about having a button on the form that pops up an "Add VIN" form. This could insert into a "temporary" table that would hold the VIN information until the ticket is created and then push the data into the permanent table, but I don't know how to display that data on the "Add Ticket" form so the tech support guy actually knows what VINs he has entered.

[Reply][Quote]

RJ Samp
Posts: 973

Re: Adding child records to ticket add form? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 13 Jul 09 12:44 PM

Basically you create a TicketID when you open the form and set the BINDID in the new VIN grid to this value. The SQL should be based on going after the VIN record from the Ticket.TicketID.

After you add a VIN record on the return of the data form in the grid (OnAdded, OnEdited, OnDeleted) grdVIN.REFRESH.

Now when the user hits CANCEL, you will have to delete the VIN records as their is not Ticket for them to hang off of and they will become orphaned.

We usually have a create routine that sets everything up, stores the record and then pops whatever screen you need in data edit mode.....in this case a Ticket table Data Form "System:Add Ticket My Way" that has all of the databound fields to ticket that you want to work on in ADD mode. Once the ticket record is stored away, you can pop with a ShowViewforRecord.....

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2025 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 8/29/2025 8:18:47 AM