I have 101 users that I want to select from a list of many offerings (1000) all of the offerings that apply to them. Currently I have a table of Users (101) and a Table of Offerings (1000).
Do I create a 3rd table for the many to many information. If yes, how do I use this 3rd table to create a form where user selects all of the offerings that apply to them? I don't think a drop down field in the user table is the way to go, correct? The offering table has two fields (offering name and state). Let me know if you need more information.
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
GWBjr
I have 101 users that I want to select from a list of many offerings (1000) all of the offerings that apply to them. Currently I have a table of Users (101) and a Table of Offerings (1000).
Do I create a 3rd table for the many to many information. If yes, how do I use this 3rd table to create a form where user selects all of the offerings that apply to them? I don't think a drop down field in the user table is the way to go, correct? The offering table has two fields (offering name and state). Let me know if you need more information.
Link to comment
Share on other sites
6 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.