-New & data from multiple DB's

[Bunny]

Hi All,

I have a Ticketing DB and users are able to add new tickets to the DB via the web.

I have this working in a basic form. The user enters data into fields and this is added as a new ticket using the -New tag.

I would like to add the following functions:

- Selecting a template for the new ticket (pre-written words for certain fields) from a Templates DB.

- Selecting a specific user to be entered into the new ticket from a USERS DB.

This is my plan of attack, described in pages:

1) Select the Template from DDBox

2) Create a New Ticket entering template field info (hidden page)

3) Select user inital from DDBox to search Users DB

4) Select exact user from search results list (store data)

5) All info from New Ticket pulled into an Edit page, & update User data and select site from Contacts DB.

I thought that I would be able to create the ticket and store the RecID in a token while I gathered other information from the other databases, and then retrieve the ticket back for editing after. However, from reading past posts around the RecID it seems that it does not work when you are accessing multiple DB's.

Could anyone offer me any advise please!? Do you think that I am on the right track in terms of the steps I perform (1-5) to create the new ticket? If so, is the RecID the right way to go, or is there a better way of doing this?

Thank you in advance!

[skuli]

You could try setting a token to a serial number that is automatically created when the new ticket is created. As long as you continue to pass the serial number token value from format file to format file you will be able to come back and search the original database for the correct record using the serial number token.

I typically only use the -RecID tag when working on one database that I am editing. By using tokens you can give them names that are easy to track across pages and databases.

Good luck.

-Skuli

[Anatoli]

Agreed! Tokens is the most reliable way to go!