Use record from one table to create new record in a different table?

Use record from one table to create new record in a different table?

Post by David Powe » Sat, 22 Dec 2007 03:26:22



Glad to have been of help. I only wish all questions could be solved so
easily. ;-)

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://www.yqcomputer.com/
 
 
 

1. Three different fields in one record referencing to three different records in another table

2. Create One Record in a New Table from several tables

I have 4 "master" tables of information - Agent, City, Dept, and Level. I
have a form that has a list box for each field in each of the 4 tables [4
fields total].

What I need is: The User clicks to select the field information needed in
each of the 4 tables, then I want them to hit a command button and it creates
a new record in another table with the selected information.

Can anyone help me?

Would greatly appreciate it!

3. automatically create a new record in a table one table away

4. select all records on one table but limit records from 2nd table

5. save ~50,000 record table sorted from one million record table

6. Updating record in one table with record in another table

7. Deleting records in one table having a matching related record in another table?

8. Can one table's record affect another tables record?

9. Compare two fields each record of table, update record or not in new table

10. Can I add records form a table and related records another table to a third table?

11. Can I add records form a table and related records another table to a third table?

12. Delete Records From a Table Using Records in Another Table.

13. Summarizing records in one table that match a different table

14. three tables - show different records that exist in one table

15. show all of the record from one table but filtered by a different table.