Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Autolookup problem in MSAccess


  • Please log in to reply

#1
red_elf

red_elf

    Member

  • Member
  • PipPip
  • 26 posts
Hiya,

My database project is due in tomorrow and i really need to fix a problem i am having. I have created a autolookup query which works perfectly but my problem is that the table does not get updated. I have two tables, one patient information and one appointments, in my query i have joined the tables so that when a PR Number is entered, three fields from the appointment field get automatically updated by looking up the matching fields in the patient information table. If i use the query or a form based on the query and add a record the record gets added with no problems however when i view the record i just added in the appointments table, it only shows the PR number with the three fields that were looked up as blank.
I have no expereince with coding or SQL and cannot make reports as they keep showing the blank fields.
:whistling:
Thanks
  • 0

Advertisements


#2
red_elf

red_elf

    Member

  • Topic Starter
  • Member
  • PipPip
  • 26 posts
Hiya
My project deadline has been extended which is great because i still have time to fix my problem, so if anyone has any advice or help it will be greatly appreciated
Thanks :whistling:
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP