Database for dummy !

[MIKE333]

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

[Newsgroup_User]

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
>
>
>

[MIKE333]

Hi Ken and thanks, however I am still lost as to how to populate my list menu, I have posted some images of my database my SQL and my insert record information along with the problems on this page My images of trouble with my Dyanmic menu

If you get a chance could you please take a look and see why I cant get my AreaNames info into my dynamic list menu .......

thank you again

Mike

[Newsgroup_User]

Mike,

Sorry - my fault!

You need a recordset to populate the dynamic list, something like:

SELECT Area.AreaID, Area.AreaName
FROM Area
ORDER BY AreaName

Then populate the dynamic list from that recordset and in the Select Value
Equal To use the Listings.AreaID

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


"MIKE333" <webforumsuser@macromedia.com> wrote in message
news:frunpm$cob$1@forums.macromedia.com...
> Hi Ken and thanks, however I am still lost as to how to populate my list
> menu,
> I have posted some images of my database my SQL and my insert record
> information along with the problems on this page
> http://www.blossomvalleyhomez.com/dbhelp.asp
>
> If you get a chance could you please take a look and see why I cant get my
> AreaNames info into my dynamic list menu .......
>
> thank you again
>
> Mike
>

[MIKE333]

No Problem Ken, THANK YOU VERY MUCH I had a feeling this wasn't that big of a deal and that it was an easy fix. I actually had done this 100's of times in the past but I have been out of it for a while. I was banging my head against every old book I had on dreamweaver to find it and you helped me a ton. Thank you

I assume I would do the same thing for the Update page ??? Correct ?

[Newsgroup_User]

Yes - exactly.

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


"MIKE333" <webforumsuser@macromedia.com> wrote in message
news:fruqdm$f5n$1@forums.macromedia.com...
> No Problem Ken, THANK YOU VERY MUCH I had a feeling this wasn't that big
> of a
> deal and that it was an easy fix. I actually had done this 100's of times
> in
> the past but I have been out of it for a while. I was banging my head
> against
> every old book I had on dreamweaver to find it and you helped me a ton.
> Thank
> you
>
> I assume I would do the same think for the Update page ??? Correct ?
>

[MIKE333 · Accepted solution]

Thank you again for your help!