I am trying to create a form in Access that incorporates, let's say, 50 stations in our plant. They are stored in a table called Stations. I would like for the user to be able to assign employees to each station, then save, and write all data to another table called Review.
The Stations data displayed on the form is not editable nor does it change from save to save, but it is written to the Review table each time. The employee information comes from an Employees table and consists of combo boxes to write the data into the Review table, along with the correspond Stations record.
I am having trouble wrapping my head around this. I cannot use a sub form as the main form needs to be a continuous-looking form. I cannot use a list box for the Stations as it ends up being too bulky and things can get overlooked easily.
In essence, the main form needs to look like an Excel spreadsheet workbook, more or less: everything on one page, but each record separately editable on the page.
Any ideas would be extremely helpful. I've been looking at this for way too long, and nothing's making sense...lol.