Help with form design

[Guest]

I am creating a DB for our locksmith. There are 5 fields, Key ring number,
Location, Number of keys, Key number, and location for Key. I would like to
create a form with Ring number, location (of Key ring) and number of keys in
all records. the most keys on one ring is 28. For the Key number and location
for key , best but in to a sub menu on the form? IF you can tell me of a
better way with out having 28 fields please do so. Thank you in advance.

 

[Guest]

I am not sure but it sounds like a listbox is what you want.

 

[John Vinson]

I am creating a DB for our locksmith. There are 5 fields, Key ring number,
Location, Number of keys, Key number, and location for Key. I would like to
create a form with Ring number, location (of Key ring) and number of keys in
all records. the most keys on one ring is 28. For the Key number and location
for key , best but in to a sub menu on the form? IF you can tell me of a
better way with out having 28 fields please do so. Thank you in advance.

Well, you clearly have a One (ring) to Many (key) relationship.
(Hmmm... "One Ring to rule them all, one ring to bind them" -
ominous!)

As such you need *TWO* tables - a table of Rings, related one to many
to a table of Keys. You would indeed base a mainform on the Rings
table and a Subform on the Keys table.

John W. Vinson[MVP]