Macros & Tables

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

Guest

I'm doing a project in Access with 2 tables. In the first table each person
is assigned an ID Number using "AutoNumber". In the second table, services
the client requested are listed using that client's ID Number. My
instructions say that there is a way for the ID Number that was assigned in
the first table to automatically be entered into the second table using a
macro. Can someone tell if it possible to use a macro for this, and if so,
how? Thanks!
 
Rather than working directly in the tables, you could do this using a main
form to display the Person info, and a subform to display the Service(s)
Requested.

By the way, you need THREE tables, not two, if you want to get the best use
of Access' features and functions.

tblPerson
PersonID
FirstName
... (other person-specific info)

tblService
ServiceID
ServiceTitle
ServiceDescription
... (other service-specific info)

trelServiceRequested
ServiceRequestedID
PersonID
ServiceID
... (other info specific to this person requesting this service -- e.g.,
RequestDate)

It would be the first and third tables you'd use in the two forms I
mentioned above.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top