Forum Discussion
Getting a date from another table
Good Morning I have two tables an open event table which is an excel document and details the name, address of people attending and the date of the event. The other is an application table which ...
Hi Anonymous
Does every event has an unique value column like event id or event name in your tables? As you said, people may not submit the application on the same day as the event, so we don't know which application is submitted for which event from the current sample data. Another question is that is it possible that one person may submit more than one application for the same event on a day or on different days before the event? And can one person submit an application just on the same day as the event or on a day after the event?
We need to have clear answers for these questions before we can move on.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.