How can I copy the ID field into another table in the same databas

  • Thread starter Thread starter Tex
  • Start date Start date
T

Tex

I want to copy a couple of fields in my main table into another table in the
same database. It's the ID field, and a memo field,

I don't know if it's possible, but I want to be able to enter data into my
main table, and have this data come up in the second table automatically (in
the relevant fields). Is it possible, and how can I do it??

Thanks
 
You should never be working directly with the tables. You should always use
forms.

In this case, you should use a form with a subform. You'd enter the data for
the main table in the form, and entering data in the subform would
automatically create the entry in the second table.
 
I want to copy a couple of fields in my main table into another table in the
same database. It's the ID field, and a memo field,

I don't know if it's possible, but I want to be able to enter data into my
main table, and have this data come up in the second table automatically (in
the relevant fields). Is it possible, and how can I do it??

Thanks
Click to expand...

It's neither necessary nor a good idea.

Particularly, you should store a memo field *only once*; they're big, they're
inefficient, they're slow! Store it once, and use a Query to join the two
tables.

It's likely that you will indeed want to store an ID field in two tables - in
one table the ID will be the "Primary Key", uniquely identifying a record; in
the other table it will be a "foreign key", serving as a link. The most common
way to populate the foreign key is to use a Form based on the "one" table,
with a Subform based on the "many", using the ID as the Master/Child Link
Field to keep them in synch.
 
Back
Top