Append data

M

msvoboda

My database is a "master table" with general data including itemcode numbers.
From there I have several subtables for additional data using the "master
itemcode numbers" as the primary key in all tables. I want to be able to
type in a new itemcode number into the "master table" and have it add that
piece of data to the subtables. Is there a way to automate this? Append
query? Is it possible to write one large append query for 5 subtables?
 
T

tina

standard procedure is to *not* enter dummy records in child tables - why
would you want a table record (in any table) that has no data except the
primary key? if you use a mainform/subform setup to enter data (you
shouldn't be entering data directly in tables), then the master itemcode
number will automatically be entered in a subform (bound to a child table)
when you enter data in a new record in the subform.

hth
 
M

msvoboda

They are not dummy records they keep the tables in sync. One master set of
record numbers with detail data in subtables. I want to be able to enter a
new item number and have only the item number create a new data line in all
tables.

Does this make sense. Cascade update only alters existing records but does
not add a new "client" line to all...???
 
J

Jeff Boyce

If the detail data applies to EVERY new record (i.e., you did say adding a
new data line in all tables), why do you have five "sub" tables to hold it?
This sounds like the data structure is more like a spreadsheet than a
normalized relational database.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top