Multiple Registration Form Organization

[eluser]Jesse Schutt[/eluser]
Sumon,

Thanks for the ideas! I will look at breaking out into several tables.

Just to clarify, this isn't for a cart or storefront. It is a registration application for events. I'm not sure if that was clear before.

You suggested that I use fields like user_id and event_id. How do I go about generating those values? I know how to use the auto_increment on the primary key, but is that what you would suggest?

Jesse

[eluser]Sumon[/eluser]
ha ha ha. Your read my post instantly. that's why you get shopping cart. Within few minutes i have changed it to event. please have a look now.
http://ellislab.com/forums/viewreply/457732/

[quote author="jschutt" date="1221100238"]
You suggested that I use fields like user_id and event_id. How do I go about generating those values? I know how to use the auto_increment on the primary key, but is that what you would suggest?
[/quote]

Exactly. user_id from registration table and event_id from event. both are auto increment and primary key.