M
MitchellCowen
I'm pretty new to Access and my books are in storage, so please have
patience with this basic question.
THe Help File advises
********************************************************
Add data to the tables by creating a form that works with more than one
table.
********************************************************
I don't really understand how to do this.
I have 3 tables:
WordList
-------------
WORD
WORD_ID
LexicalRootList
----------------------
ROOT
ROOT_ID
A word might have more than one root and different words might have the
same root, so I created a junction table
JunctinTable
-----------------
ROOT_ID
WORD_ID
JUNCTIONTABLE_ID
How do I actually add data to this table? I've been monkeying around
for a few hours now and I sill don't get it.
Ideally, I would like two combo box/drop down lists, one with WORD and
the other with ROOT, and then add a new entry to the JunctionTable with
WORD_ID and ROOT_ID.
How do I do this?
Thanks,
Mitch
patience with this basic question.
THe Help File advises
********************************************************
Add data to the tables by creating a form that works with more than one
table.
********************************************************
I don't really understand how to do this.
I have 3 tables:
WordList
-------------
WORD
WORD_ID
LexicalRootList
----------------------
ROOT
ROOT_ID
A word might have more than one root and different words might have the
same root, so I created a junction table
JunctinTable
-----------------
ROOT_ID
WORD_ID
JUNCTIONTABLE_ID
How do I actually add data to this table? I've been monkeying around
for a few hours now and I sill don't get it.
Ideally, I would like two combo box/drop down lists, one with WORD and
the other with ROOT, and then add a new entry to the JunctionTable with
WORD_ID and ROOT_ID.
How do I do this?
Thanks,
Mitch