hi folks!!
i need some help here. 3 questions here.

question #1: i'm building a checklist page which every user can delete.the checklist is the same for every user.the problem is,because the checklist is taken from database,if a user delete an item in the checklist,then the item will no longer in the database for other users to use.so i'm thinking,maybe a checklist table should be assigned to every user upon registration.but how to do that?or maybe there's another way.

question #2:how to insert multiple records into a table from a form,using either textfields or checkbox.

question #3:my page seems to display only 255 words when in my database,i've assigned Memo to the field.what' has gone wrong?is it my database or the page?

this is kinda urgent,so please anybody help me.

i'm using ASP & Access 2000

1. - Have a table which just contains Checklist Items and and ID and a table that contains Users with an ID and relate the UserID to the CheckListID using a linking table containing just UserIDs and CheckListIDs so creating a Many-To-Many relationship. Take a look here to see what I mean: www.tdsf.co.uk/tdsfdemo/Tutorial04.htm.

When a user removes a checklist item from their list, you delete the entry in the linking table to remove the ralationship between that user and the item in the checklist items table.


2. - Instead of DW MXs Insert record behavior use: Server Behaviours >> Command, then select Insert from the list in the box that opens. Now set up the INSERT in this format:

INSERT INTO tableName(Field1, Field2, Field3) VALUES(varNumber, 'varText', varMoney)

*Put single quotes around variables with a text data type.

Now set up the Variables in the window and enter the default and Run-time variables, perhaps something like:

Name | Default | Run-time

varNumber | 0 | Request("txtNumber"
varText | Whatever | Request("txtText"
varMoney | 0 | Request("txtMoney"


3. - Was the data type allways Memo? If it was originally text any data entered or imported into the table would have been truncated at 255 characters.

Regards

Owen.

-------------------------------------------------------------------------------------------
Used programming books and web development software for sale (UK only):
www.tdsf.co.uk/tdsfdemo/Shop.htm


Multiple Parameter UD4 / Access 2000 Search Tutorial:
www.tdsf.co.uk/tdsfdemo/