ADDING MORE RECORDS DEPENDING ON AMOUNT

  • Thread starter Thread starter Bobby Chun
  • Start date Start date
B

Bobby Chun

Hello,

Is there a way to add more records to a form that depends on the amount?

For example, on one form the client may have 3 records while the next client
may have 15? Do I have to create a table that lists 15 open fields or can
there be a way to add more records as needed?

I'm not sure how clear I am but it is kind of hard to explain.

Any help would be much appreciated.
 
You do that with a subform in datasheet or multiple form view. When properly
linked, the subform will hold however many records the current client has,
and allow the user to scroll through them.
 
On Tue, 30 Sep 2008 06:01:01 -0700, Bobby Chun <Bobby
Hello,

Is there a way to add more records to a form that depends on the amount?

For example, on one form the client may have 3 records while the next client
may have 15? Do I have to create a table that lists 15 open fields or can
there be a way to add more records as needed?

I'm not sure how clear I am but it is kind of hard to explain.

Any help would be much appreciated.
Click to expand...

You need TWO TABLES in a one to many relationship: one for Clients (in which
each client will have one record), and a second table for what you're calling
"records". This second table would have a ClientID, a link to the primary key
of the clients table; you could use a Form based on the clients table with a
Subform based on the "records" table to enter data.

Take a look at some of the tutorials on how Access works:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials
 
Back
Top