Hello everyone.
I have mostly worked on very simple, single table, cold fusion projects but
now I need to do something where I need to add information into two
tables. I have something like this:
PeopleTable
personID Autonumber
name Text
address Text
AppointmentTable
aptID Autonumber
PersonID Number
AptName Text
AptDate Date/Time
The information for both tables come from one entry form on a web page. I
have a second page to do the insert. When I insert the person into the
person table, how do I find out what the personID was so I can enter it
into the AppointmentTable/PersonID? Or can I do some sort of more complex
insert statement that inserts into both tables at once? What if I add a
third table? Does it get more complex? Should I setup the join as a
relationship in microsoft access?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
