Autolookup problem

  • Thread starter Thread starter Isidore
  • Start date Start date
I

Isidore

I recently restructured my database, which was built on one table, so
that is now built on several related tables.

In one pairing, the table on the one side is called Contacts and has
all the contact information. The table on the many side is
ContactHistory, which records each contact I have with a given
contact. Each of these tables are presented by a different form. The
Contact form has a button that pops up the ContactHIstory form, which
contains all the records for the Contact.

My problem is that, try as I might, I can't get AutoLookup to work, so
that when I add a new record, I have to put in the ContactID number in
manually (it is an autonumber field in Contacts and a number field in
ContactHistory). I'm sure I'm have this problem because I'm
misunderstand the instructions in Help.

Can anyone suggest a web site that might provide friendlier
instructions for less experienced users? I know I'm going to have the
same problem with the other related tables.

Or, since both forms are always open at the same time, is there a way
to have a new ContactHistory record copy the ContactID from the
Contact form?

Thanks in advance for your help and patience.

Isidore
 
My problem is that, try as I might, I can't get AutoLookup to work, so
that when I add a new record, I have to put in the ContactID number in
manually (it is an autonumber field in Contacts and a number field in
ContactHistory). I'm sure I'm have this problem because I'm
misunderstand the instructions in Help.
Click to expand...

Well... DON'T do it that way then! <g>

Put the ContactHistory Form onto the Contact Form as a Subform; use
the ContactID as the master/child link field.
 
Back
Top