[EMAIL PROTECTED] wrote: >So...thank you to Stephen for solving my Database woes the other day...now >I have this issue with updating a jobs page. > >Would someone be able to give me a brief example of how to write a script >that does the following: > >1. Client clicks on their name (contained within access database table >Client, and Recordset1), and is redirected to their job page (contained within > >access database table Job, and Recordset2). > >2. They write in the details for a job they have done, and their CV is >updated. > >3. They press submit, and a record with a job id related to their client id >is created. > >The access tables are linked by a foreign key in JobID. > >
Ok. You actually need to link it the other way around. You should have a foreign key of ClientID in your Job table. You would pass the clientid from the "client list" page to the "job form" page on the url. Then when they submit their new job details it will insert their clientid into the job table along with the job details. Make sense? Stephen ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:15:1186 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/15 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:15 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
