Junction Table to Forms

  • Thread starter Thread starter MitchellCowen
  • Start date Start date
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
 
Hi Mitch

The simplest form would be bound to only the junction table.

Make it a continuous form with two combo boxes, with the following
properties for each:

Name: WORD_ID
ControlSource: WORD_ID
RowSource: Select WORD_ID, WORD from WordList order by WORD;
ColumnCount: 2
ColumnWidths: 0
BoundColumn: 1

and

Name: ROOT_ID
ControlSource: ROOT_ID
RowSource: Select ROOT_ID, ROOT from LexicalRootList order by ROOT;
ColumnCount: 2
ColumnWidths: 0
BoundColumn: 1
 
Back
Top