Jump to content
Sign in to follow this  

link not working

Recommended Posts


I have 3 tables:

one with data for a student's University applications (UCAS).

one with university offers (key is the student name) each student has 5 offers, one of which is "Firm" and another "Insurance",hence one of the field in OFFERS is an indicator with a value of "F", "I", or space to point to these offers.

one table with University Addresses (ADDRESS). This table is linked to OFFERS, key is the university name.

Now, I need to print letters to accept the "Firm" or "Insurance" offers, so I have a layout with the student data and portal which displayes the 5 offers. From there you can go onto the layout for the letter (layout based on UCAS) which also displays info about the offer. To get this info, I've created an occurence of the table OFFERS, which I have sorted so that all the "FIRM" offers are at the start, so automatically for my student, I point to the "Firm" record. So far o good... Only it doesn't show the right univ address. The University name in my occurence "OFFERS_FIRM" is right but somehow it doesn't link with the right record in ADDRESS. Can you make any sense of this? I hope so.

Thanks for any help you can give me!

Share this post

Link to post
Share on other sites

First I would like to point out that you really should go away from using names whether its for a student or school and use meaningless ID numbers instead.

Also I think that your report should be based off your offer table occurrence. You can find all the ones for firm & print, then insurance & print.

Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Who Viewed the Topic

    1 member has viewed this topic:
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.