INSERT 3 fields from 2 menus - make 3rd field dependent on choice of 1st menu?

[Nathon Jones]

ASP/VBScript/Access db

I need to submit 3 fields into a simple table. The 3 fields are:

Event (taken from events table)
Artist (taken from artists table)
Organisation (Org ID, also taken from events table)

For the 1st two fields I have created dynamic menus, taking data from other
tables in my database.

When a user selects an event, I want the Organisation ID to change according
to their selection, BUT I want to submit the organisation ID as it's own
field.

At the moment, when I change the event in the first dynamic menu, the Org ID
doesn't change.
What do I need to do?

Thanks
Nath.

[Julian Roberts]

Sounds to me like you don't need an OrgID in this table, as the relationship
between OrgID and EventId has already been defined in the Events table

--
Jules
[url]http://www.charon.co.uk/charoncart[/url]
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

[Nathon Jones]

Hi Jules,

I do though, because I have an Intermediate table in Access, for associating
Events, Artists and Organisations.

Events Table - eventID
Artists Table - artistID
Organisation Table - orgID

Intermediate Table - interID, eventID, artistID, orgID

Make sense?

Nath.

"Julian Roberts" <newsg@charon.co.uk> wrote in message
news:d0k736$hm$1@forums.macromedia.com...

> Sounds to me like you don't need an OrgID in this table, as the
> relationship between OrgID and EventId has already been defined in the
> Events table
>
> --
> Jules
> [url]http://www.charon.co.uk/charoncart[/url]
> Charon Cart 3
> Shopping Cart Extension for Dreamweaver MX/MX 2004
>
>

[Julian Roberts]

Why would you need the OrgID in this table if the OrgID is already in the
Events table?

--
Jules
[url]http://www.charon.co.uk/charoncart[/url]
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

[Nathon Jones]

Hi Jules,

Actually, I was following some advice from someone in the Access newsgroup.

But you are, of course, right. There's no need to double that up - wonder
why they suggested that? Was something to do with an Intermediate table,
but maybe I picked them up wrong. It was because I was having trouble with
a many-to-many relationship.

Ie. Events have more than one artist, and some artists appear at more than
one event.

Anyway, I'll try taking that out, and we'll see if there's a way around it.
Thanks for the advice.

Nath.

"Julian Roberts" <newsg@charon.co.uk> wrote in message
news:d0kft9$ej0$1@forums.macromedia.com...

> Why would you need the OrgID in this table if the OrgID is already in the
> Events table?
>
> --
> Jules
> [url]http://www.charon.co.uk/charoncart[/url]
> Charon Cart 3
> Shopping Cart Extension for Dreamweaver MX/MX 2004
>
>