I just bought the Professional Recordset Wizard extension and I'm afraid I can't make head nor tail of it [:I]
I have 2 tables:
users properties
Properties contains a field called ad_owner which matches the field username in users
I also have a field in the users table called email
When I display information from the properties table I also want to display information from the users table.
In my 'psuedo MySQL' I want to display:
properties.address properties.beds properties.bathrooms users.email (where properties.ad_owner = users.username) users.telephone (where properties.ad_owner = users.username)
(and some others but this is the general idea)
I just need a kick to get me started so I hope this make sense!
Also, on my Mac running DW MX, I get broken images in some places and the layout of the window is all over the place. It's workable but it doesn't look very good. I can attach a screenshot if it helps.
Look forward to some info.
Andy |
|
|