![]() ![]() The user is instructed to remove (click the "x") on each site type they would not be willing to accept if offered to them. The form is pre-populated with the Event Name, which is hidden so the user can't change it, and all the Site Types available for that event as defined in the Events table. ![]() So instead, the form displays the link field to Site Types. In an ideal world, the form would display a Multiple Select field with the Site Types available for that event-but I realize that the options for this type of field can't be dynamically populated. The "Join the waiting list" form in the Waiting List table is used for data entry. As I have it set up, one Site Type record can be linked to multiple different Event records, but that's not mandatory-if it helped solve the problem, the Site Types could be unique to each Event. This data is repeated as "Available Site Types" in the Waiting List table via a lookup field (if it's needed). This link field defines the subset of Site Types that are available for that particular Event. Here's a highly simplified version of the base that illustrates the setup.Įach record in the Waiting List table is linked to a single Event Name record in the Events table.Įach record in the Events table is linked to one or more Site Types in the Site Types table. Site Types - lists the possible site types that could be available to a person on the waiting list.Events - defines the events for which people may be waitlisted.Waiting List - this is the "main" table, listing the people on the waiting list.From my research, I think the answer to this question is, "it can't be done", but I'm hoping I'm missing something.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |