Adding info from one form into fields with the same name in anothe

[Daniel Lees]

Hi

What i want is when information is entered into one of my tables a new
record is created in every other table and any information that is in both is
filled in, in the newly created record. The job no is in every form so when
that is entered into the sales form a new record in every other table is
created with that job no filled in with any other info from the sales table.
Is this possible if so how?

Cheers

Danny

 

[Rick B]

If there are fields from the other tables on your form, then a record will
be created in the other tables. One statement that concerns me is, "filled
in with any other info from the sales table" I hope you are not storing the
same data in more than one table. That would be redundant and would open
you up to all kinds of trouble if you only make changes to one of the
tables. A piece of data should be stored in only one place. So, you might
have a table with customer name and address data, another table with invoice
data, another table with invoice details, another table with product data,
etc,

In short, if you are entering data in your form that needs to create a
record in a related table, then the record will be created. If you are not,
then one won't. If you are storing general customer information in one
table, contact information in another, and credit data in another, then all
three tables will gain a record when you add information ot the form as long
as you add data for at least one field in each table.

Post a bit more about your structure if you want further help.