So I'm making a database to track customer complaints. In one form I have all the main information for one customer complaint. But I created a second form for additional complaints, where I only want this form to be used if there are more than one complaint. For example I have a button that opens the second form but when it opens the second form, it starts off as a new record for that form, while I want it to be on the same record that the first for is on. Is there any way to link the second form to the record in the first form? I'm new to Access so any information will be helpful.
I forgot to mention that all information on both forms are going into one table, if that makes a different, for example if there is only one complaint the additional complaint records stay empty. They are only used when there are additional complaints.