William, To make your service have custom fields to hold custom data for each customer you will need to have an options table for the service. These option tables will need to be set up before you add the service to the customers account. Go into tools and edit your service. In the Options/Attributes Table type in a name wish to call the table (this will be a table in your sql database). Save your settings on this service. On the top in the same window, click on the Options/Attributes Table tab. You should see your table in this list with a create link next to it. Click on create, this will make the table in your database. You should be able to add your services to the customers accounts now that you have an options table set up. Now to add the fields to the service you will have to do on your sql command line, or using a program like phpmyadmin (recommended). Go into your table and begin to add fields to it. There are 3 field types that I'm aware of that you can use with citrusdb. For just a standard filed you can type info into, use varchar. For a drop down menu use enum. For a large text area that you can type notes or any larger amount of text into use BLOB. Just add the fields you wish to have in this service you you should be good to go. Citrus will see the fields and give you the option to fill them as you add/edit the customers services. My apologies if this is a little vague. I'm assuming you are knowledgeable of sql. Please let me know if you need more help. - John Hurst John Hurst wrote: William, --
John Hurst |
------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________ Citrusdb-users mailing list Citrusdb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/citrusdb-users