2 Replies Latest reply on Feb 13, 2014 9:19 AM by WF7A

    Portal/Relationship set-up help, please.

    WF7A

      Title

      Portal/Relationship set-up help, please.

      Post

           I'm stuck.

           I have a table that has a primary key, CompanyName field and three date fields: Closes, Follow-up, and Interview; every record has the company name filled in as well as one or more of the date fields filled in with a date. What I want to do is create a (self-join?) portal so it lists every record with a date in chronological order, e.g.:

           Acme Company     Closes     2014-02-13

           Bozotronics     Interview     2014-02-14

           Acme Company    Interview     2014-02-20

           Acme Company      Followup     2014-02-27

           Bozotronics     Followup     2014-03-05

           How do I do that so it shows the company name, field where it's from (Closes, Follow-up, Interview) and its date? I know it's problematic from the start since ideally the dates, themselves, should've been in a child table tied to a parent table (company), but I don't want to go on a merry chase reconstructing a solution just to make this function work.

            

           TIA for your help!