Forums

I found threads related to this in the forums, but I wanted to know if there is any feature in Chronoforms V4 to make this easier.

I have several client vacation sites, each of which will have it's own registration form. All of the sites share the same database, each with a different prefix. I would like to have all registration information saved to one table in the main database prefix.

For example, the database has prefixes like:

main_ (main site)
cons_ (Consolidated Supply)
gps_ (General Plumbing)

I would like to have a registration form on the Consolidated site that will save it's data to a table called main_2012regs (for example). Is that possible? Does V4 make this any easier.

Thanks!!
Rick

Hi Rick,

I think that you can do it with either version of ChronoForms (I haven't used the DB Connection for v4 yet though). The ChronoForms table drop-downs will show you a list of all the tables in the current database regardless of prefix.

Bob

PS Not your question but for other readers you can also connect to a remote database if you hand-code the query (you can't do that with the ChronoForms DB Connection).

Bob,

Thanks for the answer. That is absolutely GREAT!!!! Should have known this extension could do what I needed...

Rick