Help in trying to add new data into 3 different tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 1 main table that has AutoNum, MemID, MemName, address, & a few other
columns. The 2nd form is suppose to go to the Products Table. What
products were added in. Both tables needs to pull in the Autonum from a 3rd
table.

I have gotten myself so confused I don't know what is going on. This
project needs to be finished by next week.

The 3 columns that needs to go into this other table (AutoNum, MemID,
MemName) needs to update a table called CTAMF in it has (AutoNum, MemID,
MemName, IDNumber (which is different then MemID) and CTAName). This is
where it is NOT working.

I've made a query. Query comes up not updateable. It's a 1 to 1 table.
Need to take all the new items and add it into CTAMF. HOW?????????

I've even tried to make the query into a table still won't work.

Please help!

Thank you.

Donna
 
I have 1 main table that has AutoNum, MemID, MemName, address, & a few other
columns. The 2nd form is suppose to go to the Products Table. What
products were added in. Both tables needs to pull in the Autonum from a 3rd
table.
Click to expand...

That isn't making sense! You don't "pull in" an Autonumber field; an
Autonumber field is a way of getting a unique, automatically assigned
Primary Key when you create a new record in a table. How are Products
related to Members? Does one member have to do with many products, or
vice versa, or can each member (use? buy?) many products, while each
product can be linked to many members?
I have gotten myself so confused I don't know what is going on. This
project needs to be finished by next week.

The 3 columns that needs to go into this other table (AutoNum, MemID,
MemName) needs to update a table called CTAMF in it has (AutoNum, MemID,
MemName, IDNumber (which is different then MemID) and CTAName). This is
where it is NOT working.
Click to expand...

So you're trying to store the MemName redundantly in a second table?
You shouldn't. You would store the member name ONCE, and once only.
Where does IDNumber come from?
I've made a query. Query comes up not updateable. It's a 1 to 1 table.
Click to expand...

"It's" a 1 to 1 table... sorry, you're not being clear.

A Table is a Table. A Table isn't a relationship; if you have a 1 to 1
relationship (which is VERY rare and almost certainly not what you
actually want) then it is a relationship *BETWEEN TWO TABLES*.
Need to take all the new items and add it into CTAMF. HOW?????????
Click to expand...

Well... don't. Storing data redundantly is NEVER necessary.
I've even tried to make the query into a table still won't work.
Click to expand...

You're assuming that we understand the meaning of your cryptic table
names and what you are trying to accomplish. Sorry, but I don't.

Stop... step back... breathe deeply <g>.

What are the Entities (real-life persons, things, and events) of
importance to your application?

How are those entities related to one another, in the real world? (See
my question above about Members and Products).

What is the application intended to accomplish?

John W. Vinson[MVP]
 
Back
Top