AnsweredAssumed Answered

Portal/Relationship set-up help, please.

Question asked by WF7A on Feb 13, 2014
Latest reply on Feb 13, 2014 by 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!

Outcomes