I'm trying to create an apartment listing website. Each property has fields like name, address, city, state, zip, phone, etc. I'd like to assign multiple units to each property (1-bedrooms, 2-bedrooms, 3-bedrooms, etc). Each unit has fields like name, beds, baths, square feet, rent, etc.
I've created two content types: Property & Unit
In the unit content type I have a Property Name text field that is a node reference to a property name. When creating Units I'm able to assign a property name using the auto complete text box. How do I access the additional information associated with the property node I referenced?
Can I use views to create a page that shows information on one property plus information on all units associated with the property? Is this a proper use for CCK & views?
I'd also like to create a view that has information on one unit but also includes all of the associated property information. Can this be done? If anyone can point me in the right direction it would be very helpful!