Drop down list to a dynamic table

[kumba]

I'm about as sharp as a marble when it comes to working with MS Access
so please bear with me.
I'm making a form that consists of your typical information: Client
name, spouse name, age, SSN#, etc.
What I am wondering is how to dynamically enter the children's
information (name, age, SSN#, etc). I was hoping to use a drop down box
that lists the numbers 0-15 to indicate the number of children in the
family, and when a number is clicked, then a "table" of fields (that
corresponds to the number clicked) opens with the appropriate fields
listed to input their data (name, age, DOB, SSN#, etc). Is there a
simple way to do this?
Thanks in advance for any advice.

Kumba

 

[Guest]

Hi kumba -- What you need is a subform for the children records, which may
require design changes to your db. With proper relationships setup between
tables and the right table structure, the subform will allow you to add as
many records for the children as needed.

For example, you would need at least three tables:

(1) Client
ClientID - PK
ClientName
etc...
(2) Spouse
SpouseID - PK
ClientID - FK
etc...
(3)Children
ChildID - PK
ClientID -- FK
etc...

This type of table structure will allow you to add a spouse or children when
needed.

 

[Frankly]

Hi kumba -- What you need is a subform for the children records, which may
require design changes to your db. With proper relationships setup between
tables and the right table structure, the subform will allow you to add as
many records for the children as needed.

For example, you would need at least three tables:

I am wondering if this is how the relationships of my database should be.
a new building can be like a spouse and the children like the Apartments.
I would be able to ad new buildings and apartments when needed and I am sure
that
I could always add new managements. if this is true you just showed me
something so much
better than the tutorials i have been reading.


(1) Management
ManagementID - PK
ManagementName> etc...

(2) BuildingID
BuildingID - PK
ManagementID - FK
etc...
(3)Apartments
ApartmentID - PK
ManagementID -- FK
etc...

if this is a also a good layout for what i need, i wonder how to add the
Area and ZipCode relations.
I never would have thought that it would be better to create a relationship
from the Apartments table
directly to the Management Table and not the Building table. what is most
important to me are the 3 tables above. i wont mind taking extra steps to
input the area code and zip code but once i know i have the foundation
correct. I can start building and take my time to learn the rest.
Thank you
Frank