Hello All,

My ASP/MSAccess skills are fairly basic, and I am trying to solve the following problem for a client.

For the sake of simplicity, there are two Access tables, "Users" and "Objects"

The Objects table has the following fields:
obj_type (cone, cylinder, sphere)
obj_property (wood, metal, plastic)
obj_material (pine, oak, aluminum, steel, pvc, abs, etc.)

The Users table needs to store demographics (first_name, last_name, etc.), along with each user's preference of objects (cone, sphere, cylinder). In addition to object preference, each user's preferences of materials (pine, steel, etc.) must be stored. Each user could potentially prefer all object types, or just one or two.

I want to display in an ASP page a recordset of an individual user's preferences (what objects the user likes, and what materials they prefer). The Users and Objects tables would be continually updated from another source, and users would need the option to change their preferences at any time.

I hope my description wasn't too convoluted, but I'm stumped at how to best to accomplish this. Any suggestions would be greatly appreciated, as well as being a great learning experience for me.

Which column relates these two table? Do you have any USERID sort of column used in both the tables that relate each other? If so use a join statement to get all the related records for each user and that should help you display the result as required. May be you can post your code to what extent you have tried, and we could take it from there on.

Cheers!

_________________________
- Vijay G
Strive for Perfection

I've only just started to figure out what I'll need to do to make this work. Don't have any code yet. Still working on how many tables I'll need, and what fields will be necessary. Not yet sure if I'm getting in over my head. Any suggestions would be greatly appreciated.

Have the user details stored in the USERS table(UserId as Primarykey) and the Object related info stored in OBJECTS table(ObjectID as PK). I would suggest using another table to relate these two using UserId and ObjectId and to record any other info relevant to that.

That should be what you are looking for.

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection

I may be getting in over my head with this project. Not sure if I know how to accomplish this. Thanks for the feedback, though.