SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Member
    Join Date
    Apr 2002
    Posts
    1
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Unhappy Returning Data to underlying tables in Access

    I have a database which needs protection during data entry. The data entry form looks up staff_surname and staff_firstname from a lookup table tblstaff. I would like to return staff_ARN which is a unique ID number(primary index). I can get access to return staff_ARN whilst displaying only the first and last name however it does not write the name fields to the underlying tables. I want it to do both. Write the staff_surname and staff_firstname to the underlying tbleventdata and auto enter the staff_ARN into the tbleventdata after selecting it based on the name selected on the form.

    Any ideas? Is this possible?

    Regards

    Greg Smith
    Coolangatta

  2. #2
    + platinum's Avatar
    Join Date
    Jun 2001
    Location
    Adelaide, Australia
    Posts
    6,441
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You may be able to combine both tables within a query and sort of combine data that way. Just be carefull when you do it though, strange things can happen!

    Maybe you should review your table structure as well, make it a bit simpler.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •