Form drop down

  • Thread starter Thread starter GaryF37
  • Start date Start date
G

GaryF37

I have the following:

Tables:
CTC
Projects

Forms:
CTC
Project Details

I want some information to populate into the CTC form from the Project
Details form or table (based on the project # field) and do some data entry
into the blank controls. The CTC form will have about different records for
the one project. How do I go about doing this, I have tried different ways,
but to no avail. Any help would be appreciated. I know it's probably
something I am missing.
 
Gary,

I don't think anyone can give a specific answer without more details of
the fields in the tables and the relationship between them. But the
general concept here is that the only field(s) in both tables should be
the fields that define the relationship between the tables. This is
typically the primary key field of the table on the "one" side of a
one-to-many relationship. No other data should be stored separately in
both tables. As for related data from the other table being displayed
on your forms and reports, this article may make sense...
http://accesstips.datamanagementsolutions.biz/lookup.htm
 
Back
Top