Subtable for a field in each row

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

Guest

hello

I'm a newbie in Access and I have a problem.

I have a table like this:

tblClassmateInformation
Fname (text)
Lname (text)
Minitial (text)
Year (integer)
Items (a single column table of inputted texts)

I was wondering,how do I make a subtable for the field Items, where inside
of field are Items of each classmate. here's a pic to better describe what I
mean.

tableoo1.jpg


I have no background on programming so just take it easy on me. thanks guys.
I'd really appreciate it if you could help me.
 
You need 3 tables:

tblClassmate:
ClassmateID AutoNumber primary key
Fname
Lname
...
but *without* the Items column.

tblItem table (one record for each item). Field:
ItemID Text primary key
Enter records for 'beaker", "microscope" etc.

tblClassmateItem, with fields:
ClassmateID Number (Long) relates to a record in tblClassmate
ItemID Text relates to a record in tblItem
So, if Jan Astor has 3 items, she has 3 records in this table.

Use the Relationships window (Tools menu) to create the relationships.

The interface is a main form bound ot tblClassmate, with a subform bound to
tblClassmateItem. The subform has a combo showing the items, so you can
choose an item on each row.
 
Back
Top