Building custom lists

[Bobadopolis]

Hi,

My users wish to have a feature in my db that allows them to compare the records within it and view a report on it.

I have implemented such a form but the functionality is not great. Basically it's a form with two subforms - the top where you choose the projects and the bottom where you view a list of the projects you've chosen. You can search the top subform using combos and select all the records currently in view (a button runs an update query based on the combo box values)

To add them to the list the user is setting a yes/no field to true. So the top subform is where yes/no field is false (and bottom subform is where yes/no is true).

They can then report on this as the report has a criteria of where the yes/no is true.

This works brilliantly, so long as there is only one user!! Otherwise they would interfere with eachother's list-building.

Does anyone have any ideas for an alternative method so that multiple users can use it? I was thinkin of making tables or something to store IDs in but don't know much about this or where to begin!!

Hope that makes sense!

Thanks in advance,

Bobadopolis

 

[Bobadopolis]

apologies for the multiple occurence of this thread