Posting from a form to a table

[DeanLinCPR]

A have a db that is used to keep track of members that talk and when. the
process is that I have a form that pulls in several names from a table
"MemberName". each record is associated with a date. I would like to have
the date of the record post to each of the names from the "MemberName" table.

 

[Jeanette Cunningham]

I imagine that you would need one table for the member names and another
table for the talks.
One member can give many talks, so the relationship is 1 to many between
MemberName table and the Talk table.

In the talk table, you would have the MemberID from the member name table,
the name of the talk and the date of the talk.
The talk table will have an autonumber primayr key - you could call it
TalkID.

In the relationships window, you click the primary key of the member name
table (MemberID - or whatever it is called in your database), and drag it
onto the MemberID field in the Talk table.



Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[DeanLinCPR]

I imagine that you would need one table for the member names and another
table for the talks.
One member can give many talks, so the relationship is 1 to many between
MemberName table and the Talk table.

In the talk table, you would have the MemberID from the member name table,
the name of the talk and the date of the talk.
The talk table will have an autonumber primayr key - you could call it
TalkID.

In the relationships window, you click the primary key of the member name
table (MemberID - or whatever it is called in your database), and drag it
onto the MemberID field in the Talk table.



Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia





.
am not sure this will help but will try.