create a log for each entry/row - listbox with data?

[Behedwin]

I have just started out with MS Access 2016.
I have created a simple form to store names, adress, phonenumber etc.
The form will act as a "staff card" to store, display and edit information about my staff.

Now i want to figure out how to create a log for each staff.
Like a listbox or something that displays on each staff card.
I want a separate form to add data to this log, like some text and dates.


How could i solve this?


As i said iam new to Access, got pretty much no experience.

[aytee111]

This is called putting the cart before the horse - you are creating this backwards. Forms do not "store" data, they only display what is stored on the tables. I suggest you learn table design before anything else, otherwise you might as well do this in Excel.

[Behedwin]

That might be the case... But i still would like to see this problem solved.
I know forms dont store data... but i might very well use the wrong type of words here... combination of bad english and beginner.

Im now trying to figure out how to setup the relationships between two tables
so that when i select a staff member in my form and import the data from the staff table i also want to import the data from the log table that are connected to that specific staff member.

to do this i tried to have a staff ID in the staff table and have the same staff ID in the log table... but im not successfull so far.

[aytee111]

There will be a main form, the record source will be the staff table. Add all the fields from the table that you wish to display. Add another field, a combobox, which will show all the records on the staff table, with the ID as the first column and (usually) the name as the second column. Set column widths for this, the ID (1st) column will be zero.

Create a second form with the record source of the log table. You can use the wizard for this too, make this tabular. Then add this second form as a subform to the first form, set the link properties to the StaffID.

In the first form, in the AfterUpdate event of the combobox, filter the form on the StaffID, the subform will filter at the same time.