I’m working on a database to manage shots in a video piece. In the most basic form, Table1 has a list of every unique shot with timings and other info. Eg.as below (the actual tables have far more fields).
Table1: SHOT __ TIMING
1 __ 01:00
2 __ 01:05
3 __ 01:14
4 __ 01:22
My 2nd table relates to a series of notes, and each single note relates to a single shot from the 1st table, but a shot can have multiple notes. E.g.
So using a Look-up on Table1 and Roll-up I can manually add and display all these, but I’d like the Look-up to auto-complete / auto-populate with all the entries on Table 2 that contain the same numbers Eg…
That’s not quite what I meant but actually your example base has been super useful for me to think around the problem and how I need to structure the data. Thanks so much! I really appreciate you taking the time.