Form drop down

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.
 
S

Steve Schapel

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down field on form 5
filtering a form based on the values of a subform 0
Custom numbering records in a subform 1
Is there a limit to Business Contacts - error messages received 3
Multiple Items Form Issues 2
Check box to control editablility of text box and return all recor 1
Update Two Tables Using One Form Contents 0
Creating a Sub-Form to record Sub-Projects 3

Top