Updating multiple tables

CodeCharge Studio

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge -> General/Other

Updating multiple tables

Author

Message

Sam

Posted: 05/20/2004, 2:42 PM

I am trying to updated muliple tables in Access.
Ex. I have employee table and insurance table. When I hit "Add New" button. I want to not only add that emp to the employee table but also add that same emp based on SSN (FK) and Today's Date in the Insurance table.

Insurance Table: SSN, Today's Date

Employee Table: SSN (PK), Name, Address, Etc..

peterr

Posts: 5971

Posted: 05/20/2004, 3:06 PM

See an example at http://docs.codecharge.com/studio/html/ProgrammingTechn...eCustomSQL.html
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com

These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

PHP Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

Home | Search | Members | Register | Login