ACCESS HELP PLEASE!!!!

[chotawala]

chotawala (Instructor) Oct 9, 2001
I NEED HELP...
IM RUNNING A GIANT DATABASE THROUGH ACCESS...AFTER COMPLETIGN MY INVENTORY LISTS...I HAVE CREATED A FORM THAT CONTAINS FIELDS THAT ARE ALSO IN VARIOUS CHILD TABLES...HOW CAN I MAKE IT, SO WHEN MY FORM OPENS AND I TYPE IN ALL THE FIELDS. THE CHILD TABLES SHOULD GET THE NEW DATA AND INCREMENT THEIR RECORDS...HOW CAN I DO THIS???

I KNOW A MACRO WOULD B DO IT..BUT I DONT KNOW HOW TO WORK WITH MACROS...PLEASE HELP

chotawala@aol.com

 

[chotawala]

Please learn what the caps lock key does, makes life much easier.

You can make various fields in an Access form either grab data or input data to several tables by naming the form and field in the cell properties.

If you need specific help I'll need the names of your tables, the name of the form and what type of updates you need to input.

AidanEnos

thanx you soo much for responding...it makes sense to make the destination of the form fields going to the child table fields...but where do you set that up...here are the tables wid their various field names...

form: server_form
fields: Server; Model; Serial Numbers; Location;...

child tables: hardware
fields: model;...

child tables: server_info
fields: server; serial numbers; location;...

does this require...VB...or a macro...

 

[Databaseguy]

The child tables should have a forign key that is t is related to the primary key on the "master" table.

Then, once you go to the relationships view, you can enable cascade update and delete. Access takes care of adding the records for you, no code needed. Tyrone Lumley
augerinn@gte.net

http://server105.hypermart.net/databaseguy