Jump to content
Sign in to follow this  
agci

Portal Auto Data Return

Recommended Posts

I have a contact table and a conference table. Both have serial # IDs attached to their records. I am trying to make a portal on the Contact layout to allow me to make a list of the conferences that a specific contact has attended. In my portal table I have a drop down list that lists all of the conferences. Once a user selects a conference from the list, I want the start date and end date to be included automatically into the table (the dates can be found in the conference table). How do I do this?

Share this post


Link to post
Share on other sites

I am assuming that you have a join table between contacts and conferences, "Attendance".

Contacts <->>Attendance

__kP_Contact ID <-->> _kF_ContactID

Attendance<<->Conference

_kF_ConfID <<-> __kP_ConfID

Attendance Table

__kP_AttendanceID

_kF_ContactID

_kF_ConfID

On Contacts, your portal is to the Attendance table. Allow for records to be created in the relationship. Format the ConfID field to be a popup with a value list of Conferences (ID-Name) showing only the second field (name).

Finally, just add the start and end date to the portal row, turning off entry in Browse mode.

Edited by Guest
Added Attendance Table Fields

Share this post


Link to post
Share on other sites

I followed the steps for relating the table and creating the portal, but it still won't enter the dates automatically. I tried adding the date fields by creating new fields and then placing them in the portal, and I also tried adding them using the Portal wizard dilogue boxes. They are linked to the Conference table. I turned off data entry in the browse mode for the date fields. This obviously is not the right way to be doing it, since it doesn't work. What did I do wrong?

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.

Guest
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  

×
×
  • Create New...

Important Information

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