How to associate one record to another
I have a table called Properties that stores information on each property I have. I would like to add to my database to record all bills that I incur, and associate each bill to the respective property.
To do this, I was originally thinking to create a layout based on Property table, with a portal from Bills table, but I realised this won't work because I don't want to create numerous bills for one property, instead I am wanting to create numerous bills, then assign it to a property. To do this how will I setup the tables and what table will the layout be linked to?
Thanks in advance.