AnsweredAssumed Answered

Update link table by selecting data from related table

Question asked by rcarran on Sep 11, 2017
Latest reply on Sep 11, 2017 by rcarran

I'm having a problem setting up a way for users to enter data. I have three tables, People, Events and PersonEvents. The PeopleEvents table contains foreign keys into the People table and the Event table, as well as a couple of other informational fields. I need to create a table-view and/or list layout so a user can add a new event for a user by selecting the person's NAME and the event NAME. Doing so should update the link table's foreign keys for the selected person and event, as well as related info. I would like the user to select a person and event by clicking on dropdowns which would show already-entered people and events. I also want the layout to show all the previously-entered people and events in an Excel-like table. I can't figure out how to do this.