AnsweredAssumed Answered

How to associate one record to another

Question asked by JohhnyHilly on Sep 14, 2014
Latest reply on Sep 15, 2014 by philmodjunk


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.