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