Help with Analyzed Table Generated Look Up IDs

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I analyzed a huge table and broke it up into separate tables. In the revision, Access created Look Up ID fields to connect the separated data, i.e. Attendance_ID, etc. The Look Up ID are numbers identical to the ID field (primary key) on the main table that was separated. I've been able to create forms using a combination of tables as the sources.

The problem comes when using a form to enter new data using a form and subform. I have to go back to the main table and individually select the new record from the secondary table from a drop-down list in order for the records to connect and show up in queries, reports, etc.

Is there any way to fix this so that new data entered using a form is automatically connected without having to do the look up? Can the field be changed? Or some other coding done?

I'm very basic at this, as you may guess, but would appreciate any help. Thanks!
 
Is there any way to fix this so that new data entered using a form is automatically connected without having to do the look up?
Click to expand...

Yes; use a Form of the "one" side table and a Subform for the "many".
Use the ID as the master/child linking field and Access will maintain
the link for you - you need not (indeed should not!) make the ID
visible to the user at all.
 
Back
Top