Hi,
Again, I'd suggest doing it the other way around.
Instead of keeping the roster table as a 'backend', I'd have it as the starting point for everything and then you just apply a combination of filters to reduce the visible rows to just the data you want to see.
If I understand you correctly, you only want to be able to view the information that has been upload from .csv files and that you also want to be able to just 'up' and 'down' arrow (or single mouse click) on any row of data to see all of the information.
In that case, perhaps think about doing it all on one form. It's up to you how much information to show in the tablegrid and how much to show outside of the grid - in the attachment, the tablegrid shows names, start and end dates and times and the photo and notes (information that is usually too big to display in the grid) is displayed outside of it (but it's just a suggestion). As you scroll up and down (or mouse click) the information that is too big to display changes accordingly.
I have put a 'data' button on the roster screen which takes you to a screen which is literally a dump of all your .csv data. I've yet to come across a scenario when someone at some stage doesn't mess something up and you need some sort of recovery option (but it can be removed if you don't think it's ever going to be used).
With regard to keys and tables - yes, the ID must be unique; MVD maintains all keys to a table automatically (called a primary key). When you link two tables in a relationship (such as staff - roster), it also maintains the link between the two tables by using a foreign key on one of the tables (which is the primary key of the table to which it is relating).
In your .csv file, the foreign keys that link 'roster' to 'staff' are missing but what we are able to do instead (although it's less efficient) is use 'firstname' which appears in both tables, as a link. But you would need to ensure that the firstname is held identically in your 'staff' table and your .csv file (it will be obvious if there is a mismatch because the photo on the 'roster' form will be blank).
Sorry for the long-winded answer but have a look at the attachment and hopefully it will give you some ideas and just ask if something's not clear.
Derek.
Post's attachments roster2a.zip 575.87 kb, 281 downloads since 2021-08-23