Database for dummy !

For the insert record you would only need one recordset for the dynamic
dropdown.

For an update page you would just need to use a JOIN. The following is what
it would look like for ColdFusion:

SELECT ListingID, ListingDetails, ListingAddress, LocationName
FROM LISTING
LEFT JOIN LOCATION
ON LISTING.LocationID = LOCATION.LocationID
WHERE ListingID = #URL.ListingID#

--
Ken Ford
Adobe Community Expert - Dreamweaver
Fordwebs, LLC
http://www.fordwebs.com


"MIKE333" <webforumsuser@macromedia.com> wrote in message
news:frsl6q$4ou$1@forums.macromedia.com...
> Little help please,
> All I need to do is have a 2 table database, TABLE LISTING, TABLE
> LOCATION
>
> In TABLE LISTING my fields are
> ListingID (PrimaryKey)
> LocationID (Links to the location table)
> ListingDetails
> ListingAddress
>
> In my TABLE LOCATION my fields are
> LocationID
> LocationName
>
> I am using access
> I am a bit out of practice with database and writing SQL
>
> Here is all I need to do
> In dreamweaver make an Insert Record page that allows me to enter into my
> LISTING table (this part I get though no problem) but I need a dynamic
> dropdown
> list on my form that will enter the LocationName into my Listing table and
> I
> cant figure out how to get it to work correctly.
>
> Do I create 2 recordsets (rsListing and rsLocation) ? and just populate
> the
> dynamic dropdown list with the Location ? ( this however I cant see how to
> get
> that info selected into my listings table........
>
> IS THERE A TUTORIAL ON JOINING DATABASES and using them in dreamweaver
> anybody
> knows about ?
>
> Thanks
>
>
>