There are 3 persons "Ada", "Charlis", "Bilgate" each of them having rental property managed by a firm "Mir Enterprises" that collect monthly rent from leasee(who is using property and pay monthly rent) and hand over to owners. The Enterprises now wants to make a website containing rent record through which Ada, Chalis and Bilgate can get information about their monthly rent e.g( recieved amount, Date, cheque No etc) by entering their user name and password. This record is saved in a table.
Problem is Here:
Ada has one flate (e.g: in sector A)
Charlis has Two flats (one in sector A and other in sector G)
Bilgate has Three flats(in Sector B, sector C and Sector D)
if each of them had only one flat then there would b one field in talbe, named "Address" But here how to store the Address of more than one flats in table And having option on front end to select which flat's rental record to be displayed.
I mean if Bilgate select "Sector B" then information about that flat should b displayed , if he select "Sector C" then info about that flat should b displayed.
This post has been edited by javedparamount: 10 August 2009 - 09:52 PM