- Joined
- Jun 23, 2015
- Messages
- 1
- Reaction score
- 0
Hi All
I hope that someone can help me, I am very new to access and need some assistance.
I am trying to create an database to log issues and have one form that records the main information about an issue (Records). from this I would like a second standalone form for adding notes (Notes).
The structure for the database is very simple and only has 2 tables; Record and Notes. these tables are relationally linked with the RecordID field from the Records table to the RecordsID in the Notes table with a one to many link.
The problem I have is that when I click the button on the Records form it open the Notes form but the information is not linked between the 2 so notes get added to the Notes table which are not linked to the Records table.
If anyone can hep me that would be great.
Thank you in advance.
I hope that someone can help me, I am very new to access and need some assistance.
I am trying to create an database to log issues and have one form that records the main information about an issue (Records). from this I would like a second standalone form for adding notes (Notes).
The structure for the database is very simple and only has 2 tables; Record and Notes. these tables are relationally linked with the RecordID field from the Records table to the RecordsID in the Notes table with a one to many link.
The problem I have is that when I click the button on the Records form it open the Notes form but the information is not linked between the 2 so notes get added to the Notes table which are not linked to the Records table.
If anyone can hep me that would be great.
Thank you in advance.