Hi there and thnx for your time
as I am new in here I am wondering if someone could help with my ... problem
the sample tables would be as follows
LastNames
ID (integer, PK, autoincrement)
LastName (string)
FirstNames
ID (integer, PK, autoincrement)
FirstName (string)
Friends
ID (integer, PK, autoincrement)
LastName_ID (integer)
FirstName_ID (integer)
DOB (date)
etc
For the Friends edit/add form, the LastName_ID will be taken from a dropdown that will be showing the lookup table: LastNames
and the FirstName_ID will be taken from a dropdown that will be showing the lookup table: FirstNames
Now my question is
when I type the first few letters of the LastName on the Friends add/edit page an Ajax dropdown will appear (so far its simple and almost autogenerated thanx to the phprunner scripts
BUT
if the LastName that will be inserted is NOT in the LastNames lookup table then
a message dialog would popup asking for a confirmation to add this newly inserted LastName to the LastNames talbe.
Should this occur the corresponded ID of the newly inserted LastName should be stored in the Friends table.
Easy ha? :-(
Hopeing that I did not confuse you
I look forward to helping me with that... :-)
Thanx again for your time guys