5 Fields

[Guest]

In my table I have a filed called "Project Team Members", it is possible to
have up to 5 team members, but not always. What I am envisioning is on the
form to have some form of a smart button that when clicked will bring up a
text box to add a name and each time the smart button is clicked another name
can be entered up to five names. Is this possible, Help?

 

[Rick B]

Sure it is possible, but not a good way to do this.

You have a one-to-many relationship. You should have a second table that
stores the project number (or some other identifier) and the UserID of the
team member. If you have a project with one team member, it will have one
record in your table. If it has four team members, you will have four
records in your table.

In your form, you'd create a subform where the team members could be added
to a project. No need for buttons and pop-ups.

 

[Guest]

Thank you Rick, this really helps.

Sure it is possible, but not a good way to do this.

You have a one-to-many relationship. You should have a second table that
stores the project number (or some other identifier) and the UserID of the
team member. If you have a project with one team member, it will have one
record in your table. If it has four team members, you will have four
records in your table.

In your form, you'd create a subform where the team members could be added
to a project. No need for buttons and pop-ups.