Problem with forms

  • Thread starter Thread starter Daniel
  • Start date Start date
D

Daniel

HI everyone,

I have a simple database with two tables, one a primary
table with customer demographics, the rest with visits.
They are linked one to many on cust ID. I have two forms,
one based demographics table and one based on vists,
linked on cutid.

Heres's the problem:

When I go on to the second table, I have put the custid
in myself, it does not come over automatically. Thats not
so much the problem, but then I have to come out of that
form and then out of the form linked to the primary
table, then open the forms again inorder to view the
info. If I just go out of the secon form then back in the
inofrmation I put there is not there, but it is on the
tables.

Hope someone can help....struggling with this!

Cheers
 
Daniel

A standard approach to handling one-to-many in forms is main form/subform.
The main form holds the "one" side, the subform holds all the related
"many".

The two are linked by the parent and child fields -- in your case, it sounds
like the customerID is your primary key in customer demographics. It would
need to be a foreign key in the visits table.

If you set up such a main form/subform, Access will automatically enter the
customerID into any subform records you enter.
 
Back
Top