adding a primary key

cicibar 03 Nov, 2010
If I am using a table from DB other than a table I created using Chronoform, and it doesn't have a primary key...what do I do?

(the table I am trying to access is the billing info of a membership component - I guess it is "the second portion" linked to another table with a primary key).

I really don't know what I'm talking about. I checked what seemed to be your only tutorial, tried to set up HTML in body section of "connection views" as I would like to see info on front end' also added pagination in header and footer; and now basically stuck because not sure what to do about primary key.

I can look up the SQL command to add a row to the billing info table and make it the primary key, and then I bet I would mess up my whole membership component by doing so...

Also, what does this mean from your tip, tricks, and hacks forum section:
EDIT 2 (01.08.2010): Added the capability of a frontend edit ID other than the primary key

_Cindy
GreyHead 03 Nov, 2010
Hi Cindy,

I think that you should be able to display info from a table without a primary key. Updating it might be tricker.

The bigger problem will be getting ChronoConeectivity to work with a secondary table "I guess it is "the second portion" linked to another table with a primary key". At the moment CC can only query a single table - though there is a hacked version in the forums that is more flexible.

There are a series (still incomplete) of ChronoConnectivity tutorials here

Bob
cicibar 03 Nov, 2010
Thank you Bob - eventually I'll see how it works out. In the meantime, brushing up on some very basic php...

Also, Chronoforms Cookbook very helpful - learning some key elements I lost along the way during my "trail and error" process.
This topic is locked and no more replies can be posted.