Jake,

Below are the two tables I have. I'm merely trying to populate a value on my
page listing houses that is a text value (status_name) from the other table.

____________
| Houses |
---------------------
| house_id (PK) |
| house_status |
| |
---------------------

____________
| Status |
----------------------
| status_id (PK)|
| status_name |
| |
---------------------

In other words, on my page listing houses, I want to list a value from the
Status table, which is the status_name, for example "Sold". I have several
categories, obviously, and getting this to work would mean I could
dynamically generate the value down the line.

This would be a dynamically generated menu but I need to sort out how to get
the above working first. Surely DW can do this!!

Any help is most appreciated.

Sincerely,




--------------------------------------------
D o u g l a s N i v e n
photo researcher/editor
--------------------------------------------

http://www.anothervietnam.com

Another Vietnam: Pictures of the War from the Other Side
* from National Geographic Books *

Vietnam's Unseen War: Pictures from the Other Side (DVD)
*from National Geographic TV*


On 5/21/04 3:19 PM, "dreamweaver@lists.blueworld.com"
<dreamweaver@lists.blueworld.com> wrote:

> douglas,
>
> can you post the rest of ya code and details of any errors your > recieving on
> the page - should be able to get a clearer view of whats going on.
>
> hth,
>
> jake
>


#############################################################
This message is sent to you because you are subscribed to
the mailing list <dreamweaver@lists.blueworld.com>.
To unsubscribe, E-mail to: <dreamweaver-off@lists.blueworld.com>
To switch to the DIGEST mode, E-mail to <dreamweaver-digest@lists.blueworld.com>
To switch to the INDEX mode, E-mail to <dreamweaver-index@lists.blueworld.com>
Send administrative queries to <dreamweaver-admin@lists.blueworld.com>