Data Organization/Schema Question

Question

Good Day,

 

I'm new to c# and database programming and I've run into a technical problem and would like to get some input.

 

My project is using c# (obviously) with MariaDB on the network.

 

I'm in the early stages of the application.

 

My issue is, I have a form that collects Customer Information (Name , # , email etc) and puts it into a table/db.

However, some Customers have  agreements (Name, #, date etc) with them.

 

I don't want to create one big table, since I don't know how many agreements some customers have, some have zero, others have 20 or more.

 

So I thought about creating an associated table, and I would join the records using an INNER Join Query.

But I'm thinking that might not work because all agreements are uniqure to individual customers.  

 

So I was wondering what is the best way to collect and store the agreements for each customer.  Is the associated table still the best way to go? Or should I just have a seperate agreements table and query it for customer name or Id each time instead?

 

Thank you for any input.

 

G