inserting records across multiple tables

professorsr wrote:
> I am creating a project management website for a friend which consists of three
> tables: one for customer info, one for project info, and one for survey
> info(completed once project is done). what I want to do is this: when the
> project is finished and survey filled out, When the submit button is clicked on
> survey form I want the field "survey complete" to have the value "Y" (for yes)
> to be input into the project table.
> I started this site with no knowledge of php and I am using dw cs3.
>

Why don't you just use a hidden form field with the value Y?

Steve

I am creating a project management website for a friend which consists of three tables: one for customer info, one for project info, and one for survey info(completed once project is done). what I want to do is this: when the project is finished and survey filled out, When the submit button is clicked on survey form I want the field "survey complete" to have the value "Y" (for yes) to be input into the project table.
I started this site with no knowledge of php and I am using dw cs3.

OH! OK. :O) That makes things a lot easier, then.

Should have something for you soon,w ill send you ane amil
"Iain71" <webforumsuser@macromedia.com> wrote in message
news:eavspd$2vt$1@forums.macromedia.com...
> if they're for each candidate they don't need to be unique - so if there
> are, say, five 'profiles', any, all or none can be attached to any
> candidate, in a many-to-many relationship.
>
> Iain

if they're for each candidate they don't need to be unique - so if there are, say, five 'profiles', any, all or none can be attached to any candidate, in a many-to-many relationship.

Iain

1. I'd be cautious about posting my full database on a google archived
group. Your database structure and table names are now public. :(

2. Try sticking to one post - I'm starting to get winded walking around. ;O)

3. We'll get to that later, i might have question sabot this post, but is it
relegated to the post I answered below?

hth,

Jon

"Iain71" <webforumsuser@macromedia.com> wrote in message
news:easfto$p6o$1@forums.macromedia.com...
> Hope someone can keep me on track here.
>
> My current database structure is :
>
> i think it's all starting to come back to me - it's basically just all
> your
> interlinking / lookup tables. so i've now got the following tables :
>
> Candidates
> ---------------
> Candidate_ID (autonumber)
> Name (text)
> ...
>
> 1, Iain
> 2, Fi
> 3, Rob
>
>
> Vacancies
> --------------
> Vacancy_ID (autonumber)
> Vacancy (text)
> ...
>
> 1, Cartographer
> 2, Gardener
> 3, Occupational therapist
> 4, Web designer
> 5, Recruitment manager
>
>
> Profiles
> -----------
> Profile_ID (autonumber)
> Profile (text)
> ...
>
> 1, Map making
> 2, Web design
> 3, Gardening
> 4, Hand therapy
> 5, Recruitment
> 6, Aviation
> 7, Sport
> 8, Travel
>
>
> VacancyProfiles
> ----------------------
> Vacancy_ID (number)
> Profile_ID (number)
> ...
>
> 1,1
> 1,2
> 4,2
> 2,3
> 3,4
> 5,5
> 5,6
>
> CandidateProfiles
> --------------------
> Candidate_ID (number)
> Vacancy_ID (number)
> ...
>
> 1,1
> 1,2
> 1,7
> 1,8
> 2,3
> 2,4
> 2,8
> 3,5
> 3,6
> 3,7
>
> and from there created two queries
>
> CandidatesQuery
> --------------------
>
> SELECT Candidates.Candidate_ID, Candidates.Name, Profiles.Profile_ID,
> Profiles.Profile
> FROM Profiles INNER JOIN (Candidates INNER JOIN CandidateProfiles ON
> Candidates.Candidate_ID = CandidateProfiles.Candidate_ID) ON
> Profiles.Profile_ID = CandidateProfiles.ProfileID;
>
> 1, Iain, 1, Map making
> 1, Iain, 2, Web design
> 1, Iain, 7, Sport
> 1, Iain, 8, Travel
> 2, Fi, 3, Gardening
> 2, Fi, 4, Hand therapy
> 2, Fi, 8, Travel
> 3, Rob, 5, Recruitment
> 3, Rob, 6, Aviation
> 3, Rob, 7, Sport
>
> and
>
> Vacancies_Query
> -------------------
>
> SELECT Vacancies.Vacancy_ID, Vacancies.Vacancy, Profiles.Profile_ID,
> Profiles.Profile
> FROM Profiles INNER JOIN (Vacancies INNER JOIN VacancyProfiles ON
> Vacancies.Vacancy_ID = VacancyProfiles.VacancyID) ON Profiles.Profile_ID =
> VacancyProfiles.ProfileID;
> ...
>
> 1, Cartographer, 1, Map making
> 1, Cartographer, 2,Web design
> 2, Gardener, 3, Gardening
> 3, Occupational therapist, 4, Hand therapy
> 4, Web designer, 2, Web design
> 5, Recruitment manager, 5, Recruitment
> 5, Recruitment manager, 6, Aviation
>
> -----------
>
> But I'm a bit unsure about how to do my insert (and edit) records pages.
> It's
> straightforward enough if I just want to add a new Candidate or Vacancy -
> just
> add a record into either table.
>
> But ideally I'd want to add any associated Profiles to each new Candidate
> or
> Vacancy at the same time - which presumably would be adding records to the
> CandidatesProfile and VacanciesProfiles tables too.
>
> Can this be done, and if so how does it need setting up?
>
> Or, does it need to be a two step process, ie adding records to the
> Candidates
> table, and then adding records to the CandidatesProfiles table?
>
> What I'm used to doing in MS Access forms would be something like using
> sub
> forms, but really not sure how to go about replicating this in a web page.
>
> Any pointers appreciated.
>
> Cheers,
> Iain
>
>