Hi,
I am building a database where users can log in and edit/add information.
I can't figure out how to make the database because one of the fields is going to be variable. This field is called Research, and may contain Research1, Research2, or however many Research locations the user wants to add.
On screen it will look like this:
Research Location # 1
Research Location # 2
Research Location # 3
etc...
How do I store this in the database? Because some users might have 2 Research locations, others might have 20, and some might just have 1.
Any ideas?
Thanx,
Chris
I am building a database where users can log in and edit/add information.
I can't figure out how to make the database because one of the fields is going to be variable. This field is called Research, and may contain Research1, Research2, or however many Research locations the user wants to add.
On screen it will look like this:
Research Location # 1
Research Location # 2
Research Location # 3
etc...
How do I store this in the database? Because some users might have 2 Research locations, others might have 20, and some might just have 1.
Any ideas?
Thanx,
Chris